Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop tablespace takes forever

Re: drop tablespace takes forever

From: Ronald J.H. Rood <ronr_at_my-deja.com>
Date: Wed, 27 Dec 2000 14:46:37 GMT
Message-ID: <92cvcc$ait$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US