| Its urgent.. [message #56813] |
Mon, 28 April 2003 00:46  |
rajmukesh
Messages: 14
Registered: March 2003
|
Junior Member |
|
|
hi
its very urgent i am getting this error
SQL> /
ERROR:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: 'C:ORACLEORADATABSLORA9ITEMP01.DBF'
I too have read the message and found that temp01.dbf is attached with the temp tablespace but when i go for editing the datafile it pops up the same message. do i have to create one more temp datafile as i am not able to edit the temp01.dbf or just executing the ALTER SYSTEM CHECK DATAFILES will work. At the time of executing this command the database is to be opened or if opened then in which mode.
Pls tell me why This error occurs? Is this due to application code or for other reason?
do answer me as early as possibe/
rgds
friend
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
