Oracle8 Export Utility Error

From: Tuan D Nguyen <tnguye12_at_polaris.umuc.edu>
Date: 17 Mar 1999 20:22:39 GMT
Message-ID: <7cp2uf$gfi$1@nova.umuc.edu>

I tried to use Export Utility with Oracle8 on NT server to process Full Database Export, everything went through correctly until all the tables were export I got the following errors (I only cut and paste the last part of the log file:

. exporting referential integrity constraints
. exporting posttables actions

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 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

Please help...
If I export a table or all tables in a schema, there is noe error. These error only happen when I export full database. Thanks.
--
TUAN NGUYEN
tnguye12_at_polaris.umuc.edu Received on Wed Mar 17 1999 - 14:22:39 CST