Re: tablespace without its .dbf file

Nanard wrote:
> 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.
>

Try with this:

ALTER DATABASE DATAFILE 86 OFFLINE DROP; DROP TABLESPACE TOTO_TBS INCLUDING CONTENTS AND DATAFILES;

-- 
Mladen Gogala
http://www.mgogala.com