Cannot delete AQ$-- tables.
300230Jan 27 2010 — edited Feb 22 2010I have a unique issue, cannot resolve and cannot find an answer on the forums.
I was working on a test schema where I have created some queue tables and queues, when the testing was finally completed we moved the entire schema to a different server.
I noticed that my Q tables were not moved but the schema had the AQ$... Q tables.
Example:
when I create a Q table 'Q_TBL_TEST', oracle creates 5 table as shown below'
'AQ$Q_TBL_TEST_G'
'AQ$Q_TBL_TEST_H'
'AQ$Q_TBL_TEST_I'
'AQ$Q_TBL_TEST_S'
'AQ$Q_TBL_TEST_T'
These tables are created when a Q table is created and deleted when a Q table is dropped. for some reason the Q table was not moved but the Oracle tables got moved.
Now I cannot create a Q table with the name 'Q_TBL_TEST' and not even drop the Oracle tables, the only way around is to create a Q table with a different name.
Is there a way to drop these tables?
Thanks...
Habeeb