Re: Export utility error

I found this at Oracle Metalink:

According to Bug 647800, in 8.0.4 you have to perform a drop operation on the   queue_table even though you did not create any queue tables explicitly.Two   queue tables are created by catdefrt.sql when a database is initialized.

  select * from dba_queue_tables;

  SYSTEM.DEF$_AQCALL   execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQCALL');

  ORA-24012 "cannot drop QUEUE_TABLE, some queues in %s have   not been dropped", you must use the force option in the procedure:

  execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQCALL', TRUE);   -AND-
  execute dbms_aqadm.drop_queue_table ('SYSTEM.DEF$_AQERROR', TRUE);

  worked!

  This is a Bug in which two queue tables are created by catdefrt.sql when the

  database is initialized regardless of whether the Replication option is   installed.

  This is fixed in version 8.0.6.

Troy Meyerink
Oracle DBA
Raytheon
Sioux Falls, SD
meyerink_at_usgs.gov

Sajnish Gupta wrote:

> Hi,
> I am trying to do a FULL database hot backup and get the following errors:
>
> EXP-00008: ORACLE error 4045 encountered
> ORA-04045: errors during recompilation/revalidation of
> SYS.DBMS_AQ_IMPORT_INTERN
> AL
> 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 781
> ORA-06512: at "SYS.DBMS_SQL", line 316
> 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
>
> What do I have to do to overcome these errors.
>
> thanks
> Sajnish
Received on Tue Jul 25 2000 - 00:00:00 CDT