Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help, extremly urgent (tablespaces)
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 PARISReceived on Tue Jan 29 2002 - 11:47:09 CST
![]() |
![]() |