Re: Drop user takes too long
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 25 Dec 2001 00:15:42 GMT
Message-ID: <OyPV7.6999$Sa5.37289_at_rwcrnsc53>
Date: Tue, 25 Dec 2001 00:15:42 GMT
Message-ID: <OyPV7.6999$Sa5.37289_at_rwcrnsc53>
Good suggestion.
"Frank van Bortel" <fbortel_at_home.nl> wrote in message
news:3C277AA3.86B84F57_at_home.nl...
> 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
Received on Tue Dec 25 2001 - 01:15:42 CET