RE: sqlloader stops

From: <lhoska_at_calibresys.com>
Date: Wed, 08 Aug 2001 10:19:12 -0700
Message-ID: <F001.0036491A.20010808095627@fatcity.com>

one after
another.
Thanks for your
interest...

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Stephen Andert   [mailto:StephenAndert_at_firsthealth.com]Sent: Wednesday, August 08,   2001 1:17 PMTo: Multiple recipients of list   ORACLE-LSubject: Re: sqlloader stops
  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>>> lyudah_at_home.com 08/08/01   07:06AM >>>If I execute one load at the time maually it loads   fine.  It gives me hardtime when I try to run multiple loads(one   after another) through the batchfile.----- Original Message   -----To: "Multiple recipients of list ORACLE-L"   <ORACLE-L_at_fatcity.com>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>>> lhoska_at_calibresys.com 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.   :-)> >> > lhoska_at_calibresys.com 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 givingme a> > > hard   time.  It loads 3 files and then stops.  I commented out   thethird> > call> > > to sqlloader thinking may be   there is something wrong with a thirdtext> > > file.  It   loaded 3 files again and stopped on the forth one.> > > There is   nothing in alert log (no errors).  Also, there is enoughspace   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: <A
  href="http://www.orafaq.com">http://www.orafaq.com> > -->   > Author: Yosi Greenfield> >   INET:
  yosi_at_comhill.com> >> > 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: 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: <A
  href="http://www.orafaq.com">http://www.orafaq.com> > -->   > Author:> >   INET: lhoska_at_calibresys.com>   >> > 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: 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).>> -->   Thanks,>> Yosi>>>

  ---------------------------------------------------------> Yosi 

  Greenfield> Oracle Certified DBA>
  ygreenfield_at_compuserve.com>>> --> Please see the   official ORACLE-L FAQ: <A
  href="http://www.orafaq.com">http://www.orafaq.com> -->   Author: Yosi Greenfield>   INET:
  yosi_at_comhill.com>> 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: 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: <A href="http://www.orafaq.com">http://www.orafaq.com-- Author: lyudah  INET: lyudah_at_home.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).

Received on Wed Aug 08 2001 - 12:19:12 CDT