-
Drop Tablespace
I have a 8.1.7 database. I deleted the datafile for a tablespace before I dropped the tablespace.
I want to drop the tablespace but I cannot open that database to drop it. It will only do to mount mode.
How do I drop the tablespace? I keep getting a message that the database is not open so I cannot drop the tablespace.
-
alter database datafile '' offline drop;
then open and 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
|