drop temp tablespace takes forever

From: maxim2k <maxim2k_at_gmail.com>
Date: Wed, 18 Oct 2006 16:16:03 +0200
Message-ID: <26d66$45363723$5277c1be$5875@news0.easynet.it>

Hi,

I'm running Oracle Database 10g R2 on Red Hat Enterprise Linux 4.

For some reason the temp01.dbf file has grown to 32GB lately!

So in order to bring it down, I tried to follow the directions in the following article:

Here is the suggested process:

create a new support temporary tablespace and make it the default for the database
drop the original TEMP tablespace
recreate a new TEMP tablespace, make it the default and drop the support tablespace

But I'm stuck at the dropping the original TEMP tablespace with the followinf command:

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES; The above command has been running for an hour or so on my server and didn't finish yet.

Is it supposed to be so slow?

How can I check its progress?

If I need to, how do I kill it without corrupting the database?

Thanks. Received on Wed Oct 18 2006 - 09:16:03 CDT