-
Hiidey Ho Boys and Girls;
OS Win NT 4.0
Oracle 8.1.6.1.0
I am doing a full export of this database and at the very end of the export I am getting this error. All of the tables seem to be fine. Here is a copy of the .LOG
exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
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 1076
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 tried using EXP and EXP80, I am using a very simple parfile
full=y
Thanks
MH
-
-
Thanks Jeff;
Keep this up and you will soon replace ocpwannabe as my hero. Unfortunately I do not have access to metalink yet. I think the export will be ok since all of the tables and there data were successfully exported, that is all we need. We will find out on Monday when we do the import, if it bombs we'll start over again.
Thanks again, MH
-
Once you get "EXP-00000: Export terminated unsuccessfully" your dump file is corrupt (it is not closed normaly), no matter if all the tables were exported successfully before the error occured. So I don't think you will be able to even read it with imp utility - it will complain at the very begining of the imp session and terminate immediately.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|