If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

This morning, when i went at office, I saw that backup didn't work this night (since 3 days). When I search why it didn't work in the log file, I read in it an error ora-01187 and ora-01110. They mean that a datafile called TOTO_TEMP2.ORA failed verification tests.

But unfortunatelly, I don't find the reason of this problem.
The files is on the disk, at the good folder, with the good name.

Can anyone help me.

Can I create a new tablespace which could replace this one. If yes, could you explain me risks there are to move users from one tablespace to the new tablespace. How can I drop the "bad tablespace" ?

Thanx,
I've already try to shutdown and restart the DB but nothing ....

The db has 50 M of SGA, archive log Mode is not activate, the instance has been created in 8.1.5 version, the db block size is set to 2048, the parameter mts_server in the init is set to 1, and time_Statistic is set to TRUE.

The OS i'm using is NT4.0 with sp4 SPack. I've remarqued that when I execute this request :

Oracle Docs says you have to issue ALTER DATABASE CHECK.
But I'm not sure if this can solve the problem. Was your database restored from backup datafile?

TOTO_TEMP2.ORA
Is this a datafile of a TEMPORARY TABLESPACE, if it is, then you can recreate this. Issue the command to verify:
select file_name, status from dba_data_files
where tablespace_name='TEMP';

Cause: The datafile did not pass the checks to insure it is part of the database. Reads are not allowed until it is verified.

Action: Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES

I think your datafile is corrupted.
You can make new users and new tablespace but if those users have created any objects in the corrupt tablespace, I am afraid, I dont think they can be recovered.
You can drop the bad tablespace after taking it offline.