finished.
Jared
MaryAnn Atkinson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/16/2003 01:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: insert and commit 1000 records
Nologging suspends redo log entries generation FOR DIRECT OPERATIONS
ONLY! Direct operations do not use SQL, they use Lisp (just kidding).
Direct insert preformats blocks and appends blocks as a whole after
the highwater mark, without using SQL in the process.
On 10/17/2003 02:43:29 PM, MaryAnn
]
10/16/2003 01:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: insert and commit 1000 records at a time
--- [EMAIL PROTECTED] wrote:
That will work, slowly.
You might like to try
MaryAnn,
To get back to the original question, use a MOD function on rownum to get
your commit point. Check the docs to make sure, but try
If mod(rownum, 1000) = 0
then
commit;
end if;
Daniel Fink
MaryAnn Atkinson wrote:
I still dont get it...
I dont know what I have done to have me
to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: insert and commit 1000 records at a time
--- [EMAIL PROTECTED] wrote:
That will work, slowly.
You might like to try something like this
insert
Assuming that the resource_id column is the PK (or at least unique) of the
RQMT table something like this should work (albeit slowly). Its missing some
definitions, but this should give you an idea on how you _might_ proceed
Kevin
DECLARE
RowCount NUMBER:= 0;
MAX
At 04:44 PM 10/17/2003, you wrote:
Got it, thanks to both of you, I really appreciate it.
maa
MaryAnn,
To get back to the original question, use a MOD function on rownum to get
your commit point. Check the docs to make sure, but try
If mod(rownum, 1000) = 0
then
commit;
end if;
Daniel Fink
yeah dont commit every 1000 records and do it in one shot. this is going to be much
slower.
why do you want to do it this way? Ive done 100m inserts with just an insert select
and one commit.
From: Maryann Atkinson [EMAIL PROTECTED]
Date: 2003/10/16 Thu AM 11:54:33 EDT
To: Multiple
I believe that this would be the best solution:
DECLARE
RowCount NUMBER:= 0;
BEGIN
/* This will work if the RESOURCE table has the parallel
attribute set. In 8i, table needs to be partitioned as well */
EXECUTE IMMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
That will work, slowly.
You might like to try something like this
insert into resource
nologging
select * from rqmt
append;
Read up on the 'append' and 'nologging' first.
Jared
Maryann Atkinson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/16/2003 08:54 AM
Please respond to
--- [EMAIL PROTECTED] wrote:
That will work, slowly.
You might like to try something like this
insert into resource
nologging
select * from rqmt
append;
How's that commiting every 1000 records?
Read up on the 'append' and 'nologging' first.
???
Maryann Atkinson
log into target database.
SQL set long 32000 (or whatever if you have long datatype involved)
SQL set arraysize 100
SQL set copycommit 1000 -- LOOKY!!
SQL COPY FROM ${REMOTE_LOGIN}/[EMAIL PROTECTED] INSERT
${LOCAL_SCHEMA}.${THE_TABLE} USING ${QUERY};
In this case QUERY will probably be select
finished.
Jared
MaryAnn Atkinson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/16/2003 01:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: insert and commit 1000 records at a time
--- [EMAIL PROTECTED
by: Subject: Re: insert and commit 1000
records at a time
[EMAIL PROTECTED]
.com
Mladen Gogala wrote:
I believe that this would be the best solution:
DECLARE
RowCount NUMBER:= 0;
BEGIN
/* This will work if the RESOURCE table has the parallel
attribute set. In 8i, table needs to be partitioned as well */
EXECUTE IMMMEDIATE 'ALTER
[EMAIL PROTECTED] wrote:
Mladen Gogala wrote:
I believe that this would be the best solution:
DECLARE
RowCount NUMBER:= 0;
BEGIN
/* This will work if the RESOURCE table has the parallel
attribute set. In 8i, table needs to be partitioned as well */
EXECUTE IMMMEDIATE
16 matches
Mail list logo