Home » RDBMS Server » Server Administration » Verification test failure.
Verification test failure. [message #56866] Thu, 01 May 2003 04:45 Go to next message
rajmukesh
Messages: 14
Registered: March 2003
Junior Member
Hi
I am facing this error ORA:01187. When I am running my select query with no condition. But when I run the same query with a where clause then it works fine. The temp01.dbf fails the verification test. How to overcome this problem.
Do help me as early as possible.
thanks
Mukesh

Report message to a moderator

Re: Verification test failure. [message #56873 is a reply to message #56866] Thu, 01 May 2003 10:05 Go to previous message
Anand
Messages: 161
Registered: August 1999
Senior Member
1. Make sure the file is available to the database.
2. Open the database
3. Run "ALTER DATABASE CHECK " command on thsi datafile.

Report message to a moderator

Previous Topic: Create a smaller dev db from prod db
Next Topic: Export-Import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 30 14:57:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.