Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop temp tablespace takes forever
On 10/18/06 4:59 PM, Brian Peasland wrote:
> If users are actively using the tablespace, the DROP command will wait
> for those sessions to release their locks on that tablespace. How long
> this takes depends on the session's activity.
Is there any way to tell if this is the actual issue?
I've tried to kill user sessions, but it didn't seem to help.
Thanks. Received on Wed Oct 18 2006 - 10:43:32 CDT