problems with export

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • steve
    #1

    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_EX P_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_EX P_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

    Tags: None
    • agis
      #2
      Re: problems with export


      "steve" <me@me.comwro te in message
      news:0001HW.BD7 56CF2000160D0F0 5095B0@news.new sguy.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_EX P_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_EX P_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



        Comment

        Previous template Next
        Working...