Re: Cannot drop user (ENQUEUING)

_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 Wed Sep 13 2006 - 15:45:27 CDT