Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> problems with export

problems with export

From: steve <me_at_me.com>
Date: Tue, 21 Sep 2004 05:30:26 +0800
Message-ID: <0001HW.BD756CF2000160D0F05095B0@news.newsguy.com>


hi,

during a full export of my export of a (Release 9.2.0.4.0 - Production ) database i'm getting the following:

I have been thru metalink, and can find nothing that is exactly the same, even though there are similar looking problems relating to export.

can anyone point me to finding the objects 25245 &25244, so that i can delete them.

. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions

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 25244
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 25245
. exporting user history table
. exporting default and system auditing options
. exporting statistics

Export terminated successfully with warnings.

steve Received on Mon Sep 20 2004 - 16:30:26 CDT

Original text of this message

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