alter tablespace x offline;
Check the tablespace has a status of "offline pending", which means that it won't offline it until the active transactions that are using the tablespace have finished processing. One you see the tablespace is offline, then you can drop it.




Reply With Quote