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 -> AQ errors on export

AQ errors on export

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Wed, 28 Nov 2001 11:45:41 -0500
Message-ID: <9u34b2$5pvnv$1@ID-85580.news.dfncis.de>


I'm getting the following errors at the end of exports. I'm not very familiar with AQ. Can anyone tell me what is causing these? At the bottom is list of the objects references in the errors.

. exporting post-schema procedural objects and actions

EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_EXP_ACTIONS", line 60
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUE_TABLES", line 17
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_AQ_EXP_QUEUE_TABLES.instance_info_exp for object 6972
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_EXP_ACTIONS", line 60
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUE_TABLES", line 17
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_AQ_EXP_QUEUE_TABLES.instance_info_exp for object 6978
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_AQ_EXP_QUEUES.create_exp for object 6976
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_AQ_EXP_QUEUES.create_exp for object 6984
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_AQ_EXP_QUEUES.create_exp for object 6982
EXP-00008: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_AQ_EXP_QUEUES.create_exp for object 6985
. exporting user history table
. exporting default and system auditing options
. exporting statistics

Export terminated successfully with warnings.
 OBJECT_ID OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ---------- ------------------------------ ------------------
      6972 UTQDBA     WMS_AQ_MESSAGE_TAB#VB          TABLE
      6976 UTQDBA     AQ$_WMS_AQ_MESSAGE_TAB_E       QUEUE
      6978 UTQDBA     WMS_AQ_REPL_REQ_TAB#VB         TABLE
      6982 UTQDBA     AQ$_WMS_AQ_REPL_REQ_TAB_E      QUEUE
      6984 UTQDBA     WMS_DEBUG_MESSAGE_QUE          QUEUE
      6985 UTQDBA     WMS_REPL_REQ_QUE               QUEUE


  • application/x-pkcs7-signature attachment: smime.p7s
Received on Wed Nov 28 2001 - 10:45:41 CST

Original text of this message

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