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