1 2 Previous Next 18 Replies Latest reply: Mar 14, 2013 12:15 AM by yxes2013 Go to original post RSS
      • 15. Re: Impdp Extra Objects
        Girish Sharma
        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
          Salman Qureshi
          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
            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
              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