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_at_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_at_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_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).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com-- Author:
Kevin Lange INET: kgel_at_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_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).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com-- Author:
INET: lhoska_at_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_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).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com-- Author:
Hillman, Alex INET: Alex.Hillman_at_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_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).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com-- Author:
INET: lhoska_at_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_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 01 2001 - 10:31:30 CDT
