Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export Errors - ORA-6552 - 6553

Export Errors - ORA-6552 - 6553

From: Doug <dpeel_at_mindspring.com>
Date: Tue, 18 Aug 1998 10:45:27 -0500
Message-ID: <35D9A197.4E4D4F5@mindspring.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US