Re: drop user hangs

> Following behaviour:
> 1. user does not exists
> --> error in the first statement, second statement executed

This is expected. Since the user did not exist, the DROP USER command should raise an appropriate error message. You can't drop what is not there.

> 2. user exists, instance just started
> --> the drop user takes about 30 sec, but executes without error, the
> second statement executes without error

What error is being raised on the CREATE USER statement? It's pretty close to impossible to diagnose your problem without any further information. Any advice would simply be a guess.

> 3. user was created after the instance started, but the user is
> definatly not logged in!
> --> the drop user statement hangs without any complains or error messages!

You'll have to find out what the DROP USER command is waiting on. In another session, you'll have to query V$SESSION_WAIT to find out.

HTH,Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"