Re: Cannot drop user (ENQUEUING)

From: _phil_ <bidon_fr_at_hotmail.com>
Date: Wed, 13 Sep 2006 20:29:18 +0200
Message-ID: <45084dfc$0$7682$626a54ce@news.free.fr>

Frank,

Thank you for your answer but do you have a link on metalink or a title to indicate in the search engine because I do not find the correct page :(

Regards
Phil

Frank van Bortel a écrit :
> 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!
>
Received on Wed Sep 13 2006 - 13:29:18 CDT