Re: Massive Update commit every 1000 records

From: Greg Rahn <greg_at_structureddata.org>
Date: Sat, 14 Nov 2009 07:25:51 -0800
Message-ID: <a9c093440911140725y755d1392s7fc3c0d8b6b34211_at_mail.gmail.com>

The fastest way to do this (given the option for exclusive access to the table) is a parallel nologging CTAS or PDML + insert /*+ append */.

On Fri, Nov 13, 2009 at 11:50 AM, Roger Xu <wellmetus_at_gmail.com> wrote:
> We need to shrink SSN to the last 4 digit.
> update sales set ssn=to_number(substr(to_char(ssn),-4));

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Sat Nov 14 2009 - 09:25:51 CST