No problem. I understand.
Listen.
Two similar messages I wrote went through. They seem to be taking about
an hour to post.
And sometimes, they're scrambled and out of order.
A second post will be coming through, and it looks like the original
post you just responded to.
Please just ignore it.
It looked like my messages weren't going through, so I sent one twice.
But I am not one to beat a dead horse.
Please ignore the second post. :-)
Cheers,
Melanie
P.S. I'm glad you ultimately got the answers you were looking for.
-----Original Message-----
MaryAnn Atkinson
Sent: Friday, October 17, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
I am the one who needs to apologize, dont hold it agaist me though,
its just sometimes pressure seems to get the best of us.
Sorry,
maa
--- Melanie Caffrey <[EMAIL PROTECTED]> wrote:
> MaryAnn,
>
> I, of course, do not have a problem with you asking a question,
> absolutely not.
>
> It was just your inference that we have you read it in the "National
> Enquirer", if I'm quoting your email correctly, seemed pretty harsh.
>
> I thought you worked with Oracle stuff. If you do not, then I
> apologize.
>
> And of course, you can pose any question you want to, on this list.
>
> No flames, I promise.
>
> Peace,
> Melanie
>
> -----Original Message-----
> Maryann Atkinson
> Sent: Friday, October 17, 2003 5:04 PM
> To: Multiple recipients of list ORACLE-L
>
> For Melanie Caffrey,
>
> Wowwwwww... Was your interference RUDE or what?
>
> > > Several people have offered you very clear and very good
> suggestions.
>
> First of all, mel, I didnt reply to "several people", I replied to
> one.
> Was that one you?
>
> > > And really, you SHOULD be reading the Oracle manuals.
>
> Second of all, mel, I dont really need a lecture, thank you very
> much!
> Third of all missy, what I was told was to read up on this and that.
> I had not been told to read "the manual", or even which one.
>
> > > Otherwise, why did you take a job working with Oracle technology?
>
> Fourth of all, mel, noone ever told you I took a job working with
> Oracle Technology.
>
> Fifth of all, I didnt know that having a job working with Oracle
> technology is a requirement for me to be in this list and ask a
> question.
> Is it?
>
> Please, very please, pretty please, flames belong back to the 90s,
> I never meant any, so please dont give me any yourself.
>
> I just dont get that mentality, I just asked a question, a simple
> little lowly question, if you dont have an answer, please dont reply
> at all, I will not hold it against you, or against anyone, I couldnt
>
> possibly.
> But please dont make me feel bad for asking it telling me to go read
> on
> (vaguely like that), just let it go...
>
> many-many thanks,
> maa
>
>
> And anything of personal nature, you can email me personally,
> you know, there is no reason to involve the whole list...
>
>
> At 04:09 PM 10/17/2003, you wrote:
> >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).
>
> --
> 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).
__________________________________
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).
