Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am attempting to run a query against an Oracl 8i database instance running on Aix. It is a simple select * against a single table. The query runs for approximately 8 hours and then throws the following error. Any insight on this would be appreciated.

ORA-12801: error signaled in parallel query server P025
ORA-01410: invalid ROWID

Thanks in advance.

share|improve this question
up vote 1 down vote accepted

A simple "SELECT *"? Does that mean no WHERE clause? I've seen this error when an index contains a corrupted rowid.

If you are using a where clause that causes one or more indexes to be used, try rebuilding them (if feasible).

share|improve this answer
This did have a where clause and yes I believe your comment to be correct - Oracle claims that you need to rebuild the table - i.e indexs and then flush the db cache. – Doug Sep 29 '10 at 19:39
Yeah @DCookie is right, this almost always means a corruption in the table somewhere, either the indexes or the data itself. If you drop all the indexes and the error still occurs, it's a restore from backup job. – Ewan Leith Oct 6 '10 at 10:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.