Re: tablespace without its .dbf file

harry.houghtaling_at_gmail.com wrote:
> 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='....';

1. Don't top post.
2. I would be more than a bit surprised if this worked. What is the origin of this advice? -- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org