Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Unanswered: Full export error!! plz help!!

    I am getting the following error when doing a full export:
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_IMPORT_INTERNAL
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
    ORA-06508: PL/SQL: could not find program unit being called
    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 other suggestions involving running the catexp.sql (ran under sys) script, but to no avail. Can I import the SYS.AQ$_SUBSCRIBERS from another database that has no errors with a full export? What does the AQ$_SUBSCRIBER object hold? Any suggestions?!!!! TIA!!

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    from the second error line it seems that
    SYS.DBMS_AQ_IMPORT_INTERNAL
    has become invalid.

    You may try to re-run catqueue.sql that is in ORACLE_HOME/rdbms/admin (logged as sys, as usual).

    This will recreate the part of the data dictionary related to AQs.


    I cannot assure... but i'm confident this should at least remove this error.

    let me know if it works,
    astropp
    astropp

  3. #3
    Join Date
    Feb 2002
    Posts
    9
    Originally posted by astropp
    from the second error line it seems that
    SYS.DBMS_AQ_IMPORT_INTERNAL
    has become invalid.

    You may try to re-run catqueue.sql that is in ORACLE_HOME/rdbms/admin (logged as sys, as usual).

    This will recreate the part of the data dictionary related to AQs.


    I cannot assure... but i'm confident this should at least remove this error.

    let me know if it works,
    astropp

    Astropp, thanks for the suggestion. I ran a catproc.sql on the db, and this is the error I get now:

    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 then ran the catqueue.sql (logged in as sys), but I still get this same error when I am doing a full export. Any more suggestions? TIA!

Posting Permissions

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