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

First:

SELECT object_type, COUNT(*)
FROM dba_objects
WHERE user = <schema_name>
GROUP BY object_type;

to get some idea of how much needs to be dropped.

Then, when dropping a schema that owns objects:

DROP USER <schema_name> CASCADE;

... you must use the CASCADE keyword.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)