Hi All,

I've successfully startup my database (8.1.6) with one of
the datafile was made offline due to corrupted. I don't have any backup.
I'm unable to drop the tablespace since it contains some
advance queueing Queue Tables.

I use "DBMS_AQADM.DROP_QUEUE_TABLE ('table_name')"
to drop the table, but it doesn't work due to some entries
remain in the queue. It also cannot be deleted as its datafile
is offline....

Anyone can help, how to drop the tablespace...