Here's my drop statement:
DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;
To solve this, I issued the following query:
SELECT b.username, b.sid, b.serial#, b.terminal
FROM v$sort_usage a, v$session
WHERE a.session_num = b.serial#
AND a.tablespace = 'TEMP';
Then I killed the sessions that were using the old temporary segment (of course I asked permission from the user before killing them).
After this, the hanged drop tablespace command continued and dropped the temp tablespace successfully.
No comments:
Post a Comment