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 -> datafile erased and oracle doesn't want to start... How to erase the tablespace when database is closed ?

datafile erased and oracle doesn't want to start... How to erase the tablespace when database is closed ?

From: Jean-Francois Vincent <jf.vincent_at_platinum.com>
Date: Wed, 19 Aug 1998 16:28:30 +0200
Message-ID: <35DAE10E.1F37@platinum.com> 





Hi, a .dbf file of a tablespace was erased and now the instance doesn't
want to start and stay started but not opened, so we can't drop the
tablespace with the command DROP TABLESPACE INCLUDING CONTENTS in the
svrmgr. How to delete the tablespace and restore the rest of the
instance ?




thank. J-Fr.
Received on Wed Aug 19 1998 - 09:28:30 CDT












Original text of this message













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