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 -> Help, extremly urgent (tablespaces)

Help, extremly urgent (tablespaces)

From: Jean-Baptiste Jacquemard <jb.jacquemard_at_pollak-prebon.fr>
Date: Tue, 29 Jan 2002 18:47:09 +0100
Message-ID: <3C56E01D.F26B21B2@pollak-prebon.fr>


Hi all,
I need to drop a tablespace but the associated file were stupidly deleted. When I do :
drop tablespace MY_SPACE including contents I got :

ORA-01116: error in opening database file 8
ORA-01110: data file 8: '/oracle/OraHome1/dbs/MY_SPACE.dbf'
ORA-27041: unable to open file

How can I drop it ?
Or is it possible to regenerate the file ? Thanks for your help...

--
Jean-Baptiste Jacquemard
========================
POLLAK PREBON
4, rue de la Bourse
75002 PARIS
Received on Tue Jan 29 2002 - 11:47:09 CST

Original text of this message

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