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

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


    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
    run catexp.sql under SYS
    Ruud Schilders
    Oracle DBA
    e-mail :
    URL :
    Twitter :

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


  4. #4
    Join Date
    Mar 2003

    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

    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:


    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