|
-
Put yuor tablespace offline;
Drop the tablespace including contents;
Remove the datafile from your file system.
If you correctly do those steps you have not any problems in shutting down and starting up your database.
However for every evenience you should take a backup of your controlfile before shutting down your DB with the command
ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
Bye
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
|