Dropping QUEUE Table

[jmodic]

Raff,

- Oracle Release?

- What do the following queries return:

SELECT queue_table FROM DBA_QUEUE_TABLES WHERE owner = 'TEST';

SELECT owner FROM DBA_QUEUE_TABLES WHERE queue_table = 'DEF$_AQCALL';

SELECT name, queue_table FROM DBA_QUEUES WHERE owner = 'TEST';

SELECT owner, name FROM DBA_QUEUE_TABLES WHERE queue_table = 'DEF$_AQCALL';

SELECT owner, object_type FROM DBA_OBJECTS WHERE object_name = 'DEF$_AQCALL';