Re: A strange variant of ORA-02391.

From: Dexter <vikram_ramakrishnan_at_ieee.org>
Date: 12 Jan 2005 20:46:22 -0800
Message-ID: <1105591582.804251.204300@z14g2000cwz.googlegroups.com>

Hi all,

the user limit is unlimited in both the instances this program accesse. version is oracle 9.2.0.4 running on solaris 5.9 the code looks like this,

merge --+ parallel(dst,4) parallel(src,4) into usr1.udest dst
using usr1.udest_at_DW_TO_AD src on (
dst.loc_id = src.loc_id
) when matched then update set
dst.loc_nm = src.loc_nm
, dst.loc_abbr = src.loc_abbr
, dst.dist_id = src.dist_id

when not matched then insert (
dst.loc_id
, dst.loc_nm
, dst.loc_abbr
, dst.dist_id

) values (
src.loc_id
, src.loc_nm
, src.loc_abbr
, src.dist_id

)

metalink doesnot help me when i browse through it. now do you have any idea about this?

-Dexter Received on Wed Jan 12 2005 - 22:46:22 CST