Re: HELP: Lost *.dbf file

Hi Chris,

   this worked for me:
   alter database yourdbnamehere
   datafile ' yourdatafilenamehere'
   offline drop;

   drop tablespace yourtablespacenamehere    including contents
   cascade constraints;

   commit;

   If you check on the tablespace by
   select tablespace_name, status from user_tablespaces;   You will see the tablespace name, but it should be marked invalid.

   Now, you can recreate the tablespace.

Good luck,
Cindy

Chris Forlano wrote:

> 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 - 22:19:31 CDT