tablespace without its .dbf file

From: Nanard <bsegonnes_at_free.fr>
Date: 21 Jun 2006 06:04:06 -0700
Message-ID: <1150895045.948651.23160@y41g2000cwy.googlegroups.com>

Hi,

I have a tablespace which has no .dbf file (it has been removed using 'rm').
I don't care to use this tablespace, but I want Oracle to be OK, and stop having this :
ORA-01157: cannot identify/lock data file 86 - see DBWR trace file ORA-01110: data file 86: '/u01/oradata/PV/TOTO_TBS.dbf' error.

How can I remove this tablespace from Oracle ?

DROP TABLESPACE TOTO_TBS; returns
SQL> drop tablespace TOTO_TBS;
drop tablespace TOTO_TBS
*
ERROR at line 1:

ORA-01122: database file 86 failed verification check
ORA-01110: data file 86: '/u01/oradata/PV/TOTO_TBS.dbf'
ORA-01251: Unknown File Header Version read for file number 86

I want to keep the Oracle instance :-)

Thanks for the answers. Received on Wed Jun 21 2006 - 08:04:06 CDT