| 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: For Melanie Caffrey
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...
>
>
>--- Jared.Still_at_radisys.com 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 <maryann_30_at_YAHOO.COM>
> > Sent by: ml-errors_at_fatcity.com
> > 10/16/2003 01:49 PM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: Re: insert and commit 1000 records at a time
> >
> >
> >
> > --- Jared.Still_at_radisys.com 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 <maryann_30_at_yahoo.com>
> > > Sent by: ml-errors_at_fatcity.com
> > > 10/16/2003 08:54 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > 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: maryann_30_at_yahoo.com
> > >
> > > Fat City Network Services -- 858-538-5051
http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> > services
> > >
> >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: maryann_30_at_yahoo.com 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: ListGuru_at_fatcity.com (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: mcaffrey_at_proximo.com 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: ListGuru_at_fatcity.com (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).Received on Fri Oct 17 2003 - 16:24:32 CDT
 |
 |