470,613 Members | 2,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

problems with export

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
1 13602

"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.

Similar topics

13 posts views Thread by DarkSpy | last post: by
205 posts views Thread by Jeremy Siek | last post: by
1 post views Thread by Janne Ruuttunen | last post: by
1 post views Thread by steve | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.