Re: sqlloader stops

[Stephen Andert]

Lyuda,   I'll jump into the game of 20 questions.   Is the batch file kicking off the jobs in serial (one after the other) or in parallel (maybe using & to put each one in the background)?         Stephen Andert >>> [EMAIL PROTECTED] 08/08/01 07:06AM >>> If I execute one load at the time maually it loads fine.  It gives me hard time when I try to run multiple loads(one after another) through the batch file. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 9:05 PM > How about using some GUI tool (or even SQL) to see what > SQL its running, if any, and what counters and waits are > incrementing... > > Good luck, keep in touch :-) > > Yosi > > > [EMAIL PROTECTED] wrote: > > > Thanks Yosi. > > No, that is not the case..:-( > > > > -----Original Message----- > > Sent: Tuesday, August 07, 2001 5:37 PM > > To: Multiple recipients of list ORACLE-L > > > > Silly ol' me. Are you out of space in your archive log destination? > > > > This is like a guessing game. :-) > > > > [EMAIL PROTECTED] wrote: > > > > > Hi List, > > > I have another problem. > > > I have a process that loads multiple (~ 20 ) files through sqlloader. It > > > works fine on other servers.  There is this one server that is giving me a > > > hard time.  It loads 3 files and then stops.  I commented out the third > > call > > > to sqlloader thinking may be there is something wrong with a third text > > > file.  It loaded 3 files again and stopped on the forth one. > > > There is nothing in alert log (no errors).  Also, there is enough space on > > > the drive where the logs are going. > > > Oracle 7.3.4 on NT. > > > If anyone has any idea please let me know... > > > > > > Lyuda Hoska > > > (703)797-8656 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yosi Greenfield > >   INET: [EMAIL PROTECTED] > > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 > > San Diego, California        -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > 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.com > > -- > > Author: > >   INET: [EMAIL PROTECTED] > > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 > > San Diego, California        -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > 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). > > -- > Thanks, > > Yosi > > > --------------------------------------------------------- > Yosi Greenfield > Oracle Certified DBA > [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yosi Greenfield >   INET: [EMAIL PROTECTED] > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 > San Diego, California        -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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.com -- Author: lyudah   INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).