Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace without its .dbf file
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 - 08:58:48 CDT