-
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|