Re: tablespace without its .dbf file

From: Cris Carampa <cris119_at_operamail.com>
Date: Wed, 21 Jun 2006 15:43:09 +0200
Message-ID: <44994d1a$0$988$5fc30a8@news.tiscali.it>

Nanard wrote:

> Is it not possible to 'only' remove the tablespace from the instance ?

I noticed that if you succeed to bring the tablespace OFFLINE then the DROP TABLESPACE command should work even if the datafile is not there anymore (tried on a 9.0.1 test system).

It's just a shot in the dark, but, according to the docs, ALTER TABLESPACE OFFLINE IMMEDIATE should not check whether tablespace files are available or not. You may want to try this command *on your test system* and see if it works for you.

Kind regards,

-- 
Cris Carampa (spamto:cris119_at_operamail.com)

All foreign wars I do proclaim
Live on blood and a mother's pain

Received on Wed Jun 21 2006 - 08:43:09 CDT