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 -> Re: exp problem : SYS.AQ$_SUBSCRIBERS

Re: exp problem : SYS.AQ$_SUBSCRIBERS

From: Troy Meyerink <meyerink_at_edcmail.cr.usgs.gov>
Date: 2000/07/25
Message-ID: <397DBDB9.2B781B3C@edcmail.cr.usgs.gov>#1/1

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

zyman_at_my-deja.com wrote:

> Hello,
> I nake a full export under an open database and at the end I got::
>
> . 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
>
> what is this SYS.AQ$_SUBSCRIBERS object is and how can I crete it? I
> don't have it in my database.( 805 on Sun Solaris)
> Thank You.
> Andy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jul 25 2000 - 00:00:00 CDT

Original text of this message

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