Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What would cause ORA-1410 (invalid rowid) on a simple select?

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

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 30 Aug 2007 20:02:40 GMT
Message-ID: <AnFBi.22903$Zg.9225@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. Received on Thu Aug 30 2007 - 15:02:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US