By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,213 Members | 2,108 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,213 IT Pros & Developers. It's quick & easy.

problems with export

P: n/a
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

Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"steve" <me@me.com> wrote in message
news:00*****************************@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


Hi steve,

i think this is a problem with the advanced queues feature of Oracle.

Try to reiinstall this feature, check metalink for this.

To find the object u can query the dba_objects view using the object id the
export mensionning.

Also try to run ultrp.sql to recompile all invalid objects before exporting.

sqlplus "/ as sysdba"

@?/rdbms/admin/utlrp.sql

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.