| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: 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.
You didn't respond to one person, you responded to the entire list.
Given the answers that appeared in this list, it seems that no one besides me read your full response to Jared's suggestion.
You state that
>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...
We all read the Web and the Oracle docs in addition to the great answers we receive on this list. If I were to take offense at someone telling me to read, then I wouldn't be able to perform my job, on most occasions.
You appeared annoyed that you were asked to read up on certain topics.
I thought you worked with Oracle stuff. You state below that you do not. 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 - 17:29:24 CDT
 |
 |