Re: Oracle8 Export Utility Error

Hi Tuan,

From the error stack it looks like there is a view which is invalid. You could try to find out
(connected as SYS)
select object_name, object_type
from user_objects
where status = 'INVALID'
and recompile them manually:
alter trigger|procedure|package|package body <object_name> compile

If that still fails, the errors will be dumped to user_errors. Hopefully that provides more conclusive evidence. For me, it looks like problems like this usually occurs when pl/sql procedures are calling each other and both need to be validated

Hth,

Sybrand Bakker, Oracle DBA

Tuan D Nguyen wrote:

> 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:36:07 CST