Then again see :
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.
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?