Re: Oracle : ORA01410-invalid ROWID error

<jani.vivek_at_gmail.com> wrote in message news:1115624105.502906.92540_at_o13g2000cwo.googlegroups.com...
> Hi all,
>
> I know this topic has been there in Google Groups many times but I
> could not find a solution my problem could relate to.
>
> We have a scheduled job(perl file) running that selects some data from
> a db and updates the same in another db. The job actually consists of
> updating features corresponding to 206 ids(one of the columns). Now the
> job is failing randomly with the ORA-01410-invalid ROWID error and it
> is failing on a select query which is operating on 6 views. The select
> query is as follows:
>
> SELECT DISTINCT
>
> UPPER(RTRIM(i.image_name || '.'|| i.major_release_number ||
> r.maintenance || r.mrenumber || '.' ||r.ed_designator ||
> r.ed_renumber,' .')) fusion_image_name,
> TRIM(UPPER(i.major_release_number)) ||
> TRIM(UPPER(r.ed_designator)) train,
> TRIM(UPPER(r.maintenance)),
> TRIM(UPPER(f.feature_name)),
> TRIM(UPPER(p.platform_name)),
> TRIM(UPPER(i.feature_set_name)),
> TRIM(UPPER(REPLACE(fsd.feature_set_desc,' ')))
> FROM sa_platform_view p,
> sa_feature_availability_view fa,
> sa_image_view i,
> sa_feature_view f,
> sa_release_view r,
> sa_feature_set_desc_view fsd
> WHERE p.platform_id = ?
> AND fa.platform_id = p.platform_id
> AND fa.feature_id = f.feature_id
> AND fa.feature_set_desc_id =
> fsd.feature_set_desc_id
> AND fa.image_id = i.image_id
> AND i.release_number_id = r.release_number_id
>
>
> The job runs this select query 206 times for 206 different platform ids
> and updates whatever records it fetches to the other db. The job fails
> at any random platform id. I know that invalid ROWID occurs when two
> processes are trying to update/delete/insert the same record at same
> time but that doesn't seem to be the case here since our job just does
> a select on the views from the first db.
>
> Please suggest the possible reasons for this error in the view context
> as soon as possible.
> Thanks in Advance,
>
> Vivek Jani
>

Are you doing any index rebuilds on the database from which you are selecting whilst this job is running ?

-- 
Regards

Jonathan Lewis

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

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005