Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Polish
    Posts
    1

    Unanswered: I Can't do exp -

    I have Oracle 8.1.7 on digital tru64. I can't do exp becouse by the end exp appear error:

    in Polish version:
    . eksport kolejek zadan
    EXP-00008: natrafiono na b--d ORACLE - 1403
    ORA-01403: nie znaleziono zadnych danych
    ORA-06512: przy "SYS.DBMS_IJOB", linia 450
    ORA-06512: przy "SYS.DBMS_IJOB", linia 482
    ORA-06512: przy linia 1
    EXP-00000: Eksport zakonczony niepomyslnie

    in English version:
    EXP-00008: ORACLE error 1403 ecncountered
    ORA-01403: no data found
    ORA-06512: at "SYS.DBMS_IJOB", line 450
    ORA-06512: at "SYS.DBMS_IJOB", line 482
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully


    I have tried reruning (under sys) catexp.sql. What can I do else?

    any suggestions?? Thanks
    RK

  2. #2
    Join Date
    May 2002
    Location
    Moscow, Russia
    Posts
    34

    Re: I Can't do exp -

    1. Try to run catalog.sql, catproc.sql, catexp.sql as sys
    2. Check if you have any invalid objects in SYS schema and recompile
    them if needed
    3. Try to run export with CONSISTENT=y parameter set

  3. #3
    Join Date
    Jun 2002
    Location
    US
    Posts
    1
    Roman,

    try to remove jobs from your job queue. Looks like error while exporting job queue.

    Peter

Posting Permissions

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