Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace without its .dbf file
"Nanard" <bsegonnes_at_free.fr> wrote in message
news:1150895045.948651.23160_at_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.
>
I assume you don't have a backup. You could export all the data except the
contents of this tablespace and then rebuild the instance. You should call
support.
Jim
Received on Wed Jun 21 2006 - 08:12:00 CDT