-
What steps are involved in dropping a tablespace?
-
1)Make a backup of the tablespace you are going to drop
2)
SQL>alter tablespace TABLESPACENAME offline;
SQL>drop tablespace TABLESPACENAME including contents;
3) then drop the datafile associated with the TABLESPACE in your system.
-
If you are not using 8i, you will not be able to take tablespace space backup, and only way is to backup all the users using that tablespace and then drop it.
Thanks
Kishore Kumar
-
Good points. In my case, I assign one tablespace to one particular user and it is easier to manage and plus I do have enough diskspace.
-
In fact.. you can take backup of a tablespace in version 7 also if you are running in arcihvelog mode.
Sanjay
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
|