Re: tablespace without its .dbf file

From: <harry.houghtaling_at_gmail.com>
Date: 21 Jun 2006 08:50:32 -0700
Message-ID: <1150905032.522414.157340@g10g2000cwb.googlegroups.com>

If you accidently delete a file and you need to drop the tablespace you can always touch the file (unix/linux touch command) which will create a empty file. After touching the file you can then take the tablespace off-line and drop it.

Harry

Nanard wrote:
> I've found !!!!!!!!!!!!!!
>
> It was on a previous message from this group :
>
> alter system check datafiles;
> alter system set standby_file_management=manual;
> alter database create datafile '/u01/oradata/PV/TOTO_TBS.dbf' as
> '/u01/oradata/PV/TOTO_to_be_deleted.dbf' size 1M;
> alter system set standby_file_management=auto;
> alter database recover;
> shutdown immediate;
> startup pfile='....';
Received on Wed Jun 21 2006 - 10:50:32 CDT