From StephenAndert@firsthealth.com Fri, 27 Jul 2001 12:57:59 -0700 From: "Stephen Andert" Date: Fri, 27 Jul 2001 12:57:59 -0700 Subject: Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8 Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 http://oracle.oreilly.com/news/oraclesqlload_0401.html and documents the fairly painless process I used to speed up data loads we are doing here.   HTH   Stephen Andert >>> steve.s.austin@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: http://www.orafaq.com-- Author: Austin, Steve S  INET: steve.s.austin@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@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).