-
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!!
-
could u please give the export command.
regards
anandkl
anandkl
-
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!
-
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
-
anandkl,
sorry that should say:
Log=/export/export.exp
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|