Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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='....';