From StephenAndert@firsthealth.com Wed, 01 Aug 2001 08:31:30 -0700 From: "Stephen Andert" Date: Wed, 01 Aug 2001 08:31:30 -0700 Subject: RE: sqlloader process dies Message-ID: MIME-Version: 1.0 Content-Type: text/plain Lyuda,   What are your settings (BINDSIZE, ROWS, etc)?    Also how big and how many rollback segments do you have?  How big is their tablespace?       If you have any questions, please feel free to drop me a note.   Stephen Andert>>> lhoska@calibresys.com 07/31/01 04:30PM >>>I could do it but the trick it to load it all at once...-----Original Message-----Sent: Tuesday, July 31, 2001 7:06 PMTo: Multiple recipients of list ORACLE-LWhy don't you try to divide this load in several parts.Alex Hillman-----Original Message-----Sent: Tuesday, July 31, 2001 6:26 PMTo: Multiple recipients of list ORACLE-LThank you Kevin.No, drive has plenty of space.Any one else has a guess?-----Original Message-----Sent: Tuesday, July 31, 2001 5:07 PMTo: Multiple recipients of list ORACLE-LSince it can't create a log file either ... how about space ???  running outof space on the machine ??-----Original Message-----Sent: Tuesday, July 31, 2001 3:42 PMTo: Multiple recipients of list ORACLE-LHi,I am experiencing a problem with sqlloader not being able to finish a largeload.  It tries to load between 1 and 2 millions records.  Sometime duringthe load it just dies. I see an attempt to create a log file but the filesize remains 0 bytes.  It remains 0 size until the next day when new processkicks off.  The described scenario occurs day after day.  It is a cron jobkicked from a batch file running multiple loads simultaneously.  There aretwo particular loads that die every day...Anyone has any idea?Thank you for your help  Lyuda-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:   INET: lhoska@calibresys.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@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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Kevin Lange  INET: kgel@ppoone.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@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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:   INET: lhoska@calibresys.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@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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hillman, Alex  INET: Alex.Hillman@usmint.treas.govFat 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@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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:   INET: lhoska@calibresys.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@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).