Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop tablespace takes forever
In article <92cgdn$om$1_at_nnrp1.deja.com>,
Luggy <dave_at_oracle-consultant.co.uk> wrote:
> Hi Susan.
>
> Sybrand is spot on regarding why it takes a long time to drop
> tablespaces. As for dropping users, there was the following script in
<snip>
> SELECT 'TRUNCATE TABLE ' || OWNER ||'.'||OBJECT_NAME || ' ;'
If many objects are involved, dropping the contraints and revoking
object privileges first may give a nice speed gain. Not as much as using
truncate table instead of delete from table but it will do ...
-- Ronald http://ronr.nl/unix-dba The best way to accellerate a computer 'running' windows is by gravitation Sent via Deja.com http://www.deja.com/Received on Wed Dec 27 2000 - 08:46:37 CST