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

From: <Prasada.Gunda1_at_hartfordlife.com>
Date: Fri, 27 Jul 2001 12:15:51 -0700
Message-ID: <F001.00357CAC.20010727121103@fatcity.com>

Steve,

Even we do have the same kind of requirement. AFAIK, there is no way except INSERT with APPEND hint (Direct Load Insert). See Direct-load Insert chapter in concepts manual. Unfortunately Direct load insert works with Insert .. select, not Insert .. values syntax.

hth,
prasad

                                                                                       
       
                    "Austin,                                                           
       
                    Steve S"             To:     Multiple recipients of list ORACLE-L  
       
                    <steve.s.aust        <ORACLE-L_at_fatcity.com>                        
       
                    in_at_xo.com>           cc:                                           
       
                    Sent by:             Subject:     any way to stop rollback for     
       
                    root_at_fatcity.        dml?/8.1.7.1/Solaris 8                        
       
                    com                                                                
       
                                                                                       
       
                                                                                       
       
                    07/27/2001                                                         
       
                    03:02 PM                                                           
       
                    Please                                                             
       
                    respond to                                                         
       
                    ORACLE-L

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: steve.s.austin_at_xo.com

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: ListGuru_at_fatcity.com (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: Prasada.Gunda1_at_hartfordlife.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Jul 27 2001 - 14:15:51 CDT