What steps are involved in dropping a tablespace?
Printable View
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.
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