Orace error during FULL EXPORT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Orace error during FULL EXPORT

  1. #1
    Join Date
    Feb 2002
    Posts
    14
    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.

    PLEASE, any suggestions?? TIA!!

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    could u please give the export command.

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Feb 2002
    Posts
    14
    exp sys/***@cred full=y compress=n buffer =1000000 file=/export/export.dmp
    file=/export/export.exp

    This is run on a UNIX command prompt (Solaris 8), using ORACLE 8.1.7

    thanks!

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    why have set file parameter twice.
    type exp=help you will get list of parameters that can be specified with exp utility.

    regards
    anandkl
    anandkl

  5. #5
    Join Date
    Feb 2002
    Posts
    14
    anandkl,

    sorry that should say:

    Log=/export/export.exp



  6. #6
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    The metalink links in this post will give you the solution. It is a bug with the QUEUE tables.

    Good luck.

    http://www.dbasupport.com/forums/sho...threadid=19011
    David Knight
    OCP DBA 8i, 9i, 10g

  7. #7
    Join Date
    Feb 2002
    Posts
    14
    Thanks for the reply!

    Unforuntately, I don't have a metalink account. Is there a readonly id, or could someone email me the following documents on metalink?

    thanks again!!

    http://metalink.oracle.com/metalink/...UG&p_id=647800
    http://metalink.oracle.com/metalink/...X&id=1059224.6
    http://metalink.oracle.com/metalink/...p_id=14733.999

  8. #8
    Join Date
    Feb 2002
    Posts
    14
    Email is: sculder7@hotmail.com

Posting Permissions

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


Click Here to Expand Forum to Full Width