Jonathan Lewis wrote:
> "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 ?
>
Good question. I will check that out.
Received on Fri Aug 31 2007 - 12:06:40 CDT
