| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL SQL cursor help
Stephen,
Thanks, That sounds like an easy way to accomplish what I was trying to do. I'll have to play around with that.
Stephen
>>> Stephen.Lee_at_DTAG.Com 03/22/04 07:51AM >>>
If you must have periodic commits, the COPY command works very well.
set copycommit 5000 (5000 is as high as you can go, iirc)
set long 65000 (if needed)
set arraysize 100 (or whatever)
copy from joebob/sma_at_box1 insert billybob.local_table using SELECT *
FROM
sma a WHERE exists (select 1 from mr15421 b where a.sched_id =
b.sched_id
and a.proc_cd = b.proc_cd and a.proc_catg_cd = b.proc_catg_cd and
a.compnnt_typ_cd = b.compnnt_typ_cd and a.eff_dt = b.eff_dt);
I don't know this for a fact, but I get that feeling that the copy
command
uses the sql loader mechanism underneath the covers. Whatever it uses,
it's
moves data at a good rate of speed.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Mar 23 2004 - 18:20:06 CST
 |
 |