Re: ORA-01555 query

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Mar 2007 06:02:38 -0700
Message-ID: <1173877358.208545.50740@b75g2000hsg.googlegroups.com>

On Mar 14, 6:49 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
> I see ORA-01555.
> Can we find table name from this output.
>
> ORA-01555 caused by SQL statement below (Query Duration=0 sec, SCN:
> 0x0000.00676aeb):
> Wed Mar 14 14:50:31 2007
> select lxOid,lxVal from lxString_1be8cbb6 where lxOid in
> (:va,:vb,:vc,:vd,:ve,:vf,:vg,:vh,:vi,:vj,:vk,:vl,:vm,:vn,:vo,:vp,:vq,:vr,:vs,:vt,:vu,:vv,:vw,:vx,:vy,:vz,:v26,:v27,:v28,:v29,:v30,:v31,:v32,:v33,:v34,:v35,:v36,:v37,:v38,:v39,:v40,:v41,:v42,:v43,:v44,:v45,:v46,:v47,:v48,:v49,:v50,:v51,:v52,:v53,:v54,:v55,:v56,:v57,:v58,:v59)
> and lxType=:v60

Normally I would expect the target of the FROM in a query, "lxString_1be8cbb6" in the posted statement, to be the table or view that is being selected against. Are you stating that is not the case?

HTH -- Mark D Powell -- Received on Wed Mar 14 2007 - 08:02:38 CDT