Oracle 8.0.4 export error EXP-0008: Oracle error 4045 encoutered

From: Huy Vu <huyv_at_usa.net>
Date: Mon, 7 Jun 1999 02:23:34 -0400
Message-ID: <cBJ63.42759$r_1.22814030@newscontent-02.sprint.ca>

Hi all,

I tried to export an oracle database (8.0.4, update to 8.0.4.3 on Dec Unix 4.0D) but it stopped with errors below:

. about to export EXTDATA1's tables via Conventional Path ...
. exporting referential integrity constraints
. exporting posttables actions

EXP-00008: ORACLE error 4045 encountered ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_IMPORT_INTERL

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 787
ORA-06512: at "SYS.DBMS_SQL", line 328
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

I don't remember with .sql scripts that I tried to ran to allow to import a dump file of Oracle 7....to Oracle 8....

Thanks in advance for any idea..

H.V Received on Mon Jun 07 1999 - 01:23:34 CDT