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

exp problem : SYS.AQ$_SUBSCRIBERS

From: <zyman_at_my-deja.com>
Date: 2000/07/24
Message-ID: <8liamb$9dl$1@nnrp1.deja.com>#1/1

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 Mon Jul 24 2000 - 00:00:00 CDT

Original text of this message

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