ORA-01403 during full export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01403 during full export

  1. #1
    Join Date
    Jan 2001
    Posts
    3,131
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    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

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  



Click Here to Expand Forum to Full Width