RE: sqlloader process dies

[Stephen Andert]

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 >>> [EMAIL PROTECTED] 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 PM To: Multiple recipients of list ORACLE-L Why don't you try to divide this load in several parts. Alex Hillman -----Original Message----- Sent: Tuesday, July 31, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Thank you Kevin. No, drive has plenty of space. Any one else has a guess? -----Original Message----- Sent: Tuesday, July 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Since it can't create a log file either ... how about space ???  running out of space on the machine ?? -----Original Message----- Sent: Tuesday, July 31, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hi, I am experiencing a problem with sqlloader not being able to finish a large load.  It tries to load between 1 and 2 millions records.  Sometime during the load it just dies. I see an attempt to create a log file but the file size remains 0 bytes.  It remains 0 size until the next day when new process kicks off.  The described scenario occurs day after day.  It is a cron job kicked from a batch file running multiple loads simultaneously.  There are two 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: [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: Kevin Lange   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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex   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).