We have couple of queries wrt to impdp:
IMPDP creates '%AQ$_KUPC%' and '%AQ$KUPC%' tables in database and oracle_maintained flag is N in sys.dba_objects, shouldn't this flag be Y as its created internally?
Since the above tables are created by IMPDP , shouldn't this be deleted automatically after the operation ?
If the above queue tables persists in the DB, can we drop them using dbms_aqadm.drop_queue_table() will there be any impact ?
Can you please help us to understand this more. Thanks in advance.
Regards,
Adarsha HS