HELP: Lost *.dbf file

Just an experimental database, no backups, one of my tablespace files got zapped.
I want to drop the tablespace, but cannot without the file.

ORA-01116: error in opening database file 6 ORA-01110: data file 6:
'/home/oracle/dba/admin/tdp1/data/data01/tdadmints_data.
dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory Additional information: 3

• or, if I try to copy another tablespace file, Oracle figured it out with ---

ORA-01122: database file 6 failed verification check ORA-01110: data file 6:
'/home/oracle/dba/admin/tdp1/data/data01/tdadmints_data.
dbf'
ORA-01251: Unknown File Header Version read for file number 6

How can I remove this tablespace from my database without the tablespace file?

Thanks in advance,

Chris

--
Chris Forlano
TMS Project Manager
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Thu Sep 02 1999 - 19:30:54 CDT