Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: any way to stop rollback for dml?/8.1.7.1/Solaris 8

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

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Mon, 30 Jul 2001 06:19:52 -0700
Message-ID: <F001.00358D00.20010730062552@fatcity.com>

Hey Steve,

The Rock is coming back to Raw tonight - hope you're ready!! :0)

g

-----Original Message-----

Sent: Saturday, July 28, 2001 12:30 AM
To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
  INET: guy.hammond_at_avt.co.uk

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 Mon Jul 30 2001 - 08:19:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US