Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Export Errors - ORA-6552 - 6553
Hello all...
I'm having a problem getting an export to work using NT4.0 Server with Oracle 8.0.3. When I run the export, the display indicates exporting many tables and when it gets to the SYS schema tables to export, I get the following errors
exporting posttables actions
ORA-4045:errors during recompilation/revalidation of
SYS.DBMS_AQ_IMPORT_INTERNAL
ORA-6552:PL/SQL:Compilation unit analysis terminated ORA-6553:PLS-905:object SYS.AQ$_SUBSCRIBERS is invalid ORA-6508:PL/SQL:could not find program unit being called. ORA-6512:at line 1 ORA-6512:at "SYS.DBMS_SYS_SQL", line 787 ORA-6512:at "SYS.DBMS_SQL", line 328 ORA-6512:at "SYS.DBMS_EXPORT_EXTENSION", line 82 ORA-6512:at "SYS.DBMS_EXPORT_EXTENSION", line 133 ORA-6512:at line 1 EXP-00000:Export terminated unsuccessfully
In the documentation that I have, there is no reference to the errors ORA-6552 or 6553. I cannot find the object AQ$_SUBSCRIBERS anywhere. I already ran the CATALOG.SQL, CATEXP.SQL, and CATREP.SQL. I noticed that there where several other SQL files in the area around CATALOG. Are any of these a "patch" to fix a problem.
Any and all help is appreciated.
Doug
dpeel_at_mindspring.NOSPAM.com Received on Tue Aug 18 1998 - 10:45:27 CDT
![]() |
![]() |