Re: tablespace without its .dbf file

From: GD <goran99_remove_at_yahoo.com>
Date: Wed, 21 Jun 2006 15:50:27 +0200
Message-ID: <e7bj1a$sej$1@ss408.t-com.hr>

Nanard wrote:

>> I assume you don't have a backup.  You could export all the data except the
>> contents of this tablespace and then rebuild the instance.  You should call
>> support.

> Thanks, but there's nothing easier ? The instance is created/used by a
> big application we use/need, I have only created a TBS/user for our
> needs. I do care about the instance but not about the tablespace.
>
> Is it not possible to 'only' remove the tablespace from the instance ?
>

startup mount; (if shutdown)
alter database datafile '/u01/oradata/PV/TOTO_TBS.dbf' offline drop; alter database open;
drop tablespace toto_dbs including contents;

Regards... Received on Wed Jun 21 2006 - 08:50:27 CDT