Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace without its .dbf file

Re: tablespace without its .dbf file

From: Nanard <bsegonnes_at_free.fr>
Date: 21 Jun 2006 06:58:48 -0700
Message-ID: <1150898328.879733.238780@r2g2000cwb.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US