Re: drop tablespace takes forever

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 27 Dec 2000 09:44:01 +0100
Message-ID: <92caun$6jqe2$1@ID-62141.news.dfncis.de>

drop tablespace drops all objects one by one and has to perform extent management on all objects dropped, updating the datadictionary. So what is causing the delay is now quite obvious. No other solutions are available than exporting the database and rebuilding it from scratch, *not* importing the affected user.

Regards,

Sybrand Bakker, Oracle DBA

<susana73_at_hotmail.com> wrote in message news:92c2ob$n5f$1_at_nnrp1.deja.com...
> Hi,
>
> I am trying to drop a tablespace by 'drop tablespace ts including
> contents' and it hangs for almost 10 hours now. I did not drop the user
> because drop user also takes forever(I ctrl-C it). The tablespace
> contains some object which has many extents which is not good. Does it
> affect? Does 'drop tablespace' actually performs a SQL DELETE or it
> DROP objects one by one?? Any ideas?
>
> The tablespace is about 5GB and about 75% filled. I don't notice any
> performance problem on this instance until I see this.
>
> Thanks,
> Susan
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 27 2000 - 02:44:01 CST