Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.