Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Unanswered: export error...NEED immediate help plz!!

    All,

    I am getting the following error when doing a full export:

    EXP-00008: ORACLE error 1403 encountered
    ORA-01403: no data found
    ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
    ORA-06512: at "SYS.DBMS_SQL", line 316
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully


    I have tried reruning (under sys) catalog.sql, catproc.sql, and catrep.sql

    No avail. I am running the export in UNIX (Solaris 8), and Oracle is 8.1.7



    PLEASE, any suggestions?? TIA!!

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    run catexp.sql under SYS
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Feb 2002
    Posts
    9
    Just ran catexp.sql as internal (connected using svrmgrl) and itstill did not resolve the issue.

    =(

  4. #4
    Join Date
    Mar 2003
    Location
    England
    Posts
    1

    Catproc etc

    Try running the scripts under SVRMGRL, connected as INTERNAL. I have known CATPROC to fail to create some stuff when run under SYS - but I've never had the time to go back and find out what happened.

  5. #5
    Join Date
    Mar 2003
    Posts
    4

    Export Error

    Problem Explanation:
    ====================
    This can be caused by running the script 'catnoqueue.sql' without first dropping all the queue tables in the database.

    Solution Explanation
    ====================
    The script 'catnoqueue.sql' has been run which drops the tables DEF$AQCALL and DEF$AQERROR. The corresponding rows in SYS.EXPACT$ are not dropped. Prior to running 'catnoqueue.sql', check for and drop any existing queue tables. To ascertain the existence of any queue tables, from SQL*Plus issue the following command to list all queue tables:

    SELECT * FROM dba_queue_tables

    To drop the queue tables, from SQL*Plus issue the following command: execute dbms_aqadm.drop_queue_table('<queue table name>')

    Solution Description:
    =====================
    If 'catnoqueue.sql' has already been run, then you need to delete from SYS.EXPACT$ rows for non-existent queue tables. The following steps will allow a full export to run successfully:

    All rows from the SYS.EXPACT$ table for the function package DBMS_AQ_IMPORT_INTERNAL need to be deleted.

    1. Login into Server Manager as INTERNAL or SYS; or, login into SQL*Plus as SYS

    2. Enter the following SQL command:

    DELETE FROM SYS.EXPACT$
    WHERE FUNC_PACKAGE = 'DBMS_AQ_IMPORT_INTERNAL';

    After the statement issue a 'commit' so the statement can take effect.

    3. Exit Server Manager or SQL*Plus.

    4. Now you should be able to do a full database export.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •