Re: What would cause ORA-1410 (invalid rowid) on a simple select?

"Chuck" <skilover_nospam_at_bluebottle.com> wrote in message news:AnFBi.22903$Zg.9225_at_trnddc08...
> Oracle 10.2.0.2 64 bit, Solaris 10.
>
> Here's the select? Occasionally we get an ORA-1410 on it but 99.9% of the
> time it works fine. It's coming from a web based application that uses a
> product called hibernate to access to the database.
>
> SELECT DISTINCT flipbook2_.name AS col_0_0_
> FROM flip_page_media flippageme0_,
> flip_page flippage1_,
> flipbook flipbook2_
> INNER JOIN user_content flipbook2_1_
> ON flipbook2_.content_id = flipbook2_1_.content_id
> INNER JOIN content flipbook2_2_
> ON flipbook2_.content_id = flipbook2_2_.content_id
> WHERE flippage1_.content_id = flipbook2_.content_id
> AND flippageme0_.flip_page_id = flippage1_.flip_page_id
> AND flippageme0_.media_id = :1
>
> I have checked the indexes used for corruption and found none.

When the ORA-01410 occurs are there any
index rebuilds going on at around the same time ?

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html