ORA-00376&ORA-01110 DATAFILES cannot be read at this time.
hello all,
I need a help.
I have Oracle database 10.2 runing on redhat enterprise linux and I have this error when run INSERT querry on a table. the error is:
Error at line 1
ORA-00376: fichier 79 ne peut être lu à cette heure
ORA-01110: fichier de données 79 : '/data5/oradata/mapict_mois_encours/mapict_encours_05.dbf'
the database run on noarchivelog mode and has no valid backup.
physically i don't find mapict_encours_05.mdf.
I create another datafile mapict_encours_04.mdf but the error still be the same.
see the output of this querry:
select status, enabled from v$datafile where file#=79