Re: HELP: Lost *.dbf file

You have a three step procedure:
1.) do an offline drop of the datafile
  ALTER DATABASE 'db_sid'
  DATAFILE 'file_name'
  OFFLINE DROP; 2.) Drop the tablespace

3.) Recreate the tablespace.

This worked for me when i accidently deleted the datafile for my temp tablespace.

Take care,
Ashok

In article <37CF16BE.2B4208BD_at_nortelnetworks.com>,   Chris Forlano <cforlano_at_nortelnetworks.com> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 13:08:09 CDT