| its very urgent pls help me! [message #56796] |
Fri, 25 April 2003 06:55  |
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'
do give me the solution urgently
rgds
friend
|
|
|
|
| Re: its very urgent pls help me! [message #56797 is a reply to message #56796] |
Fri, 25 April 2003 08:09  |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
ORA-1187...
Cause: The datafile did not pass the checks to insure it is part of the database. Reads are not allowed until it is verified
Solution: Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES
hth
A
|
|
|
|
| Re: its very urgent pls help me! [message #56804 is a reply to message #56797] |
Sat, 26 April 2003 00:18 |
MeenaMukesh
Messages: 6
Registered: March 2003
|
Junior Member |
|
|
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/
thanks
friend
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
