Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Drop user causes session to freeze with no error message returned?
steven.fox_at_dfas.mil wrote:
> We are operating databases in 9i and 10g...
> The command "drop user user" is not returning anything
> (the session freezes and when you kill it, it does not go away unless
> you kill -9. This is happening even if you are logged in as a DBA or
> for that matters sysop...
> It is happening to both our 9i and 10g databases. One is test and the
> other is production...
> Steven.fox_at_dfas.mil
>
Are you sure? drop user [whatever] may take a while, as
references need to be checked, priveleges need to be
revoked, etc, etc.
And it should not return anything, but for a comment:
user dropped.
-- Regards, Frank van BortelReceived on Fri May 06 2005 - 08:39:41 CDT