Re: drop temp tablespace takes forever

From: maxim2k <maxim2k_at_gmail.com>
Date: Wed, 18 Oct 2006 17:40:14 +0200
Message-ID: <bbb3e$45364adc$5277c1be$6435@news0.easynet.it>

On 10/18/06 5:21 PM, DA Morgan wrote:
> Temporary tablespaces are not datafiles ... they are tempfiles. Go to
> tahiti.oracle.com and look up the correct syntax.

I see, but then why the Oracle server didn't raise an error when I issued the command below?

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES; What should be the correct command for a temporary tablespace?

BTW, my SQL client is still stuck waiting for the Oracle server to complete the command above.

Thanks. Received on Wed Oct 18 2006 - 10:40:14 CDT