Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot delete AQ$-- tables.

300230Jan 27 2010 — edited Feb 22 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2010
Added on Jan 27 2010
2 comments
2,099 views