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:[EMAIL PROTECTED]]
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        <[EMAIL PROTECTED]>

                    [EMAIL PROTECTED]>           cc:

                    Sent by:             Subject:     any way to stop
rollback for            
                    root@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: [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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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).
-- 
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).

Reply via email to