Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp problem : SYS.AQ$_SUBSCRIBERS
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
![]() |
![]() |