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

Yes; many thanks! Unfortunately some of this process is updates, but some of it is inserts, so it will still help...

Also the link to sqlldr stuff seems helpful as well. There seems to be quite a bit able to be done here; need to get busy with the docs...

Thanks also to those who responded with "nologging" -- but this affects redo, not rollback. I've already set the tables as nologging, but the rollback to undo the transaction is another set of overhead that if I could eliminate would speed things up... But thank you for the helpful spirit in which the message was sent... :)

happy weekend...
Steve

-----Original Message-----
[mailto:Prasada.Gunda1_at_hartfordlife.com] Sent: Friday, July 27, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
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).