Re: problems with export

"steve" <me_at_me.com> wrote in message
news:0001HW.BD756CF2000160D0F05095B0_at_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"

_at_?/rdbms/admin/utlrp.sql Received on Tue Sep 21 2004 - 09:02:48 CEST