Dear all ,
I got this error on my database 11gR2:
ORA-01186: file 201 failed verification tests
ORA-01122: database file 201 failed verification check
ORA-01110: data file 201: '/u01/app/oracle/oradata/dbprod/temp01.dbf' <<<<<<<<---------- TEMPFILE issue
ORA-01203: wrong incarnation of this file - wrong creation SCN
I have seen a topic similar to this issue , the solution is to drop temp tablespace & recreate it again.
Now my question is , If i drop my temp TS including its datafiles , it will affect my database or not ?
Need your support.
Regards