Update ??

From: Shreeni <srao-1_at_home.com>
Date: Sat, 03 Nov 2001 09:55:43 -0800
Message-ID: <F001.003BBD0A.20011103095518@fatcity.com>

Hi List,

By any chance is it possible to use "nologging" with UPDATE ??, the reason is, there is an update statement within a procedure to update 13 mil rows, after about 20K rows the procedures freezes or just crawls, asked my DBA about sufficient Roll backs and he would not speak to me, so can anyof you help ??

TIA
--

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

Author: Shreeni
  INET: srao-1_at_home.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 Sat Nov 03 2001 - 11:55:43 CST