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

Home -> Community -> Usenet -> c.d.o.server -> Re: BULK UPDATE help

Re: BULK UPDATE help

From: Jagjeet Singh <jagjeet.malhi_at_gmail.com>
Date: Tue, 07 Aug 2007 13:17:41 -0700
Message-ID: <1186517861.224630.255150@r34g2000hsd.googlegroups.com>


I think, he does not mean by using bulk update feature. He wants to update the bulk data (millions of row ) with minimum redo/undo/less time.

Sometime it was faster approach for me. But If approachable ..

create table new_t as select c1, null c2, null c3, c4 from t. drop the old table
rename this to old
create indexes + grant again. Received on Tue Aug 07 2007 - 15:17:41 CDT

Original text of this message

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