Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> What would cause ORA-1410 (invalid rowid) on a simple select?
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. Received on Thu Aug 30 2007 - 15:02:40 CDT
![]() |
![]() |