Re: Cannot drop user (ENQUEUING)

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 13 Sep 2006 20:24:46 +0200
Message-ID: <ee9n9p$d4t$1@news4.zwoll1.ov.home.nl>

fitzjarrell_at_cox.net schreef:
> _phil_ wrote:

>>
>> WHAT CAN I DO ???????????

>
> Open a service request/TAR with Oracle. There is a way to get these
> tables dropped and I have successfully used it with specific direction
> from Oracle Support. I cannot say how this is done, as I don't work
> for Oracle Support (and I won't assume the liability involved for
> giving out such information should something go wrong), which is why
> you need to open a TAR/SR.
>

Well, this is actually a well-known-problem, that has a script attached to it.
Search metalink, and be very careful with the scripts - about every db version has it's own script (but for 10G...).

One short cut I know of:
if your user has a default tablespace, that is only used by this user, drop the tablespace including contents and datafiles.
That will teach 'em!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Sep 13 2006 - 13:24:46 CDT