MaryAnn,
First of all, Wow! Is your reply to this group ever rude.
Several people have offered you very clear and very good suggestions.
And really, you SHOULD be reading the Oracle manuals. Otherwise, why
did you take a job working with Oracle technology?
I don't think the problem is with the answers you've received, but in
your disinterest in listening to them.
Melanie
-----Original Message-----
MaryAnn Atkinson
Sent: Friday, October 17, 2003 2:43 PM
To: Multiple recipients of list ORACLE-L
I still dont get it...
I dont know what I have done to have me confused more
than I first asked the question...
--- [EMAIL PROTECTED] wrote:
> My bad. The SQL is not quite right: 'append' is a hint:
> alter table resource nologging;
dont know what nologging does.
> insert /*+ append */ into resource
> select * from rqmt;
me no understand... me no see 1000 anywhere...
> Read up on direct load insert in the concepts manual,
> along with nologging.
And one more thing... If I asked the question, thats just it,
I asked a question. If anyone knows the answer, please offer it here,
but dont tell me to go read it up in the national enquirer or
I-dont-know-where-you-mean...
Folks, please, if we have something to offer, lets go ahead,
if not, just bypass that email and read another one...
thanks,
maa
>
> Bypass the redo and undo - no need for commits.
>
> Just back it up when 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] 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 <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 10/16/2003 08:54 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject: insert and commit 1000 records at a time
> >
> >
> > I have 2 tables, Rqmt and Resource, same structure.
> >
> > I need to take all almost-one-million records from Rqmt and
> > insert them to Resource. So far this worked ok:
> >
> > DECLARE
> > RowCount NUMBER := 0;
> >
> > BEGIN
> > SELECT Count(*)
> > INTO RowCount
> > FROM RQMT;
> >
> > IF RowCount > 0 THEN
> >
> > INSERT INTO RESOURCE
> > SELECT Resource_Id, Classification
> > FROM RQMT;
> >
> > RowCount := SQL%RowCount;
> >
> > DBMS_OUTPUT.PUT_LINE ('TABLE Resource: ' || RowCount || '
> > Rows
> > transitioned.');
> > COMMIT;
> > ELSE
> > DBMS_OUTPUT.PUT_LINE ('TABLE Resource is empty. No data
> > transitioned.');
> > END IF;
> >
> > EXCEPTION
> > WHEN OTHERS THEN
> > Raise;
> > END;
> > /
> >
> >
> > But now I need to commit every 1000 records. Any suggestions as to
> > what would be the best way? I dont think ROWNUM would help here,
> > because it would pick the same 1000 records every time, causing
> > primary key violation...
> >
> >
> > thx
> > maa
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Maryann Atkinson
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> >
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> Author: MaryAnn Atkinson
> INET: [EMAIL PROTECTED]
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MaryAnn Atkinson
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Melanie Caffrey
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
