Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Drop user causes session to freeze with no error message returned?

Re: Drop user causes session to freeze with no error message returned?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 06 May 2005 15:39:41 +0200
Message-ID: <d5frr4$fro$2@news2.zwoll1.ov.home.nl>


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 Bortel
Received on Fri May 06 2005 - 08:39:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US