Orace error during FULL EXPORT

[bhsieh]

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!!

[anandkl]

could u please give the export command.

regards
anandkl

[bhsieh]

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!

[anandkl]

why have set file parameter twice.
type exp=help you will get list of parameters that can be specified with exp utility.

regards
anandkl

[bhsieh]

anandkl,

sorry that should say:

Log=/export/export.exp

[dknight]

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

[bhsieh]

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

[bhsieh]

Email is: sculder7@hotmail.com