Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8

[Stephen Andert]

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 >>> [EMAIL PROTECTED] 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 uses are 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 of ways to do this?  Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S   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).