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

"steve" <me (AT) me (DOT) com> wrote

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