Steve,
As far as speeding up the sqlldr process, you could take a look at an
article on O'Reilly's web site. It's at <A
href="http://oracle.oreilly.com/news/oraclesqlload_0401.html">http://oracle.oreilly.com/news/oraclesqlload_0401.html%a0and
documents the fairly painless process I used to speed up data loads we are doing
here.
HTH
Stephen Andert
>>> steve.s.austin_at_xo.com 07/27/01 12:02PM
>>>Does anyone know of a way to inhibit rollback from being
generated for DML?We've got a data warehouse load process that we're
trying to speed up(involving sqlldr and then some DML afterwards.) The
staging tables it usesare entirely for this process -- there's no need to
rollback if it fails;we'd truncate them and start again with that set of
data.Aside from sqlldr direct mode and import direct mode, can anyone
think ofways to do this? Thanks,Steve-- Please see
the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Austin,
Steve S INET: steve.s.austin_at_xo.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 Fri Jul 27 2001 - 14:57:59 CDT
