This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Mar 13, 2013 10:15 PM by yxes2013 Go to original post RSS
  • 15. Re: Impdp Extra Objects
    Girish Sharma Guru
    Currently Being Moderated
    Ok. It means, if you says :
    select object_name from all_objects where owner = 'SYS' AND status != 'VALID' order by 1;
    then in the above query you will get table name AQ$_KUPC$DATAPUMP_QUETAB_P for sure. If yes, then try to :
    SQL> exec dbms_aqadm.drop_queue_table(queue_table =>'SYS.KUPC$DATAPUMP_QUETAB', force=> TRUE);
     
    PL/SQL procedure successfully completed.
     
    SQL> BEGIN
      2  dbms_aqadm.create_queue_table(queue_table => 'SYS.KUPC$DATAPUMP_QUETAB',
      3    multiple_consumers => TRUE,
      4    queue_payload_type =>'SYS.KUPC$_MESSAGE',
      5    comment => 'DataPump Queue Table',
      6    compatible=>'10.1.0');
      7  EXCEPTION
      8    WHEN OTHERS THEN
      9      IF SQLCODE = -24001 THEN NULL;
     10      ELSE RAISE;
     11      END IF;
     12  END;
     13  /
     
    PL/SQL procedure successfully completed.
    Then again see :
    SQL> select object_name from all_objects where owner = 'SYS' AND status != 'VALID' order by 1;

    Now, no rows should be there for data pump system table AQ$_KUPC$DATAPUMP_QUETAB_P as invalid.

    Source:http://damir-vadas.blogspot.in/2010/08/ora-24203-operation-failed-queue-table.html

    Regards
    Girish Sharma
  • 16. Re: Impdp Extra Objects
    SalmanQureshi Expert
    Currently Being Moderated
    HI,
    Huhuhu but my recycle bin is empty so what are these kinds of table?
    Which recyclebin is empty? In the database from where you exported and recyclebin was empty before you did export? OR recycle bin of destination database is empty?

    What export level you used? database level or schema level?

    You should not worried about object under SYS schema during export/import

    Salman
  • 17. Re: Impdp Extra Objects
    yxes2013 Newbie
    Currently Being Moderated
    Hi dear, Issue resolved. :) I found out that if you do impdp there are temp tables created. thanks
    I just thought my dump has virus in it :D
  • 18. Re: Impdp Extra Objects
    yxes2013 Newbie
    Currently Being Moderated
    Hi dear, Issue resolved. :) I found out that if you do impdp there are temp tables created. thanks
    I just thought my dump has virus in it :D
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points