Prev: ora-01461 when importing a 10.2 dump
Next: ORA-00603: "ORACLE server session terminated by fatal error"
From: Steve Robin on 14 Mar 2007 06:49
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

From: Mark D Powell on 14 Mar 2007 09:02
On Mar 14, 6:49 am, "Steve Robin" <ocma...(a)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,:v­s,: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 --





 | 
Pages: 1
Prev: ora-01461 when importing a 10.2 dump
Next: ORA-00603: "ORACLE server session terminated by fatal error"