Re: Export Errors - ORA-6552 - 6553

Update on this problem. The error only occurs when doing a full database export. I can export by table or user but not full. Not sure if that helps, but...

Doug wrote:

> 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 - 14:10:15 CDT