Re: Drop user takes too long

Jim Kennedy wrote:
>
> drop the tables first then the user and see how long the whole process
> takes.
> spool droptabs.sql
> select 'drop table '||owner||'.'||table_name||';' from dba_tables where
> owner='THE USER' order by table_name;
> spool off
> _at_droptabs.sql
> drop user ...
>
> Jim
<snip!>
I'd truncate the tables (not drop!) and then drop the user.

-- 
Gtrz,

Frank van Bortel