Re: Cannot drop user (ENQUEUING)

From: _phil_ <bidon_fr_at_hotmail.com>
Date: Thu, 14 Sep 2006 07:58:56 +0200
Message-ID: <4508ef9f$0$28156$636a55ce@news.free.fr>

Thank you Maxim :)

Maxim Demenko a écrit :

> _phil_ schrieb:

>> 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!
>>>

> 
> The Note 203225.1 seems to be the most recently updated version.
> 
> Best regards
> 
> Maxim

Received on Thu Sep 14 2006 - 00:58:56 CDT