Re: drop user cascade

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 06 Apr 2007 02:38:50 GMT
Message-ID: <_oiRh.120080$115.49623@newsfe10.phx>

rmohanvp_at_gmail.com wrote in news:1175824736.058252.263280 @q75g2000hsh.googlegroups.com:

> I am trying to drop a user which is also the schema owner, so as to
> make fresh import of schema. But some how I am the statement drop user
> scm1 cascade hangs, as I don't see any result after several hours.
>
> Can someone help to guide me what could be the problem.
>
> cheers
>
>

SQL> SHOW USER
displays what?

Prior to issuing the DROP USER command do: SQL> ALTER USER SET SQL_TRACE=TRUE What is the output from TKPROF after processing the *trc file? Received on Thu Apr 05 2007 - 21:38:50 CDT