From: stag@hq.acn.gr   
      
   "steve"  wrote in message   
   news: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   
   >   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)