ORA-01157: Cannot identify/lock data file 203 & ORA-01110:datafile 203:'..../dbs/TS_TEMP'
Posted on 2004-11-12
Working Oracle 9 & Linux Red Hat. I cannot access any TEM partitions & the above error are displayed.
At the same time the SYSTEM ROLLBACK statements display a new extension with a size of 0 bytes & I do not know
how to modify such value as an error ORA-30019 is displayed when I tried to modify it.
I also did a shutdown immediate & and then a RESTART but the same error still happens.
Can you give me any advise?