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.
|
Results 1 to 5 of 5
Thread: tablespaceThreaded View
|
Click Here to Expand Forum to Full Width |