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: How to best reset a column to null on very large tables.

Re: How to best reset a column to null on very large tables.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Mar 2005 14:03:43 -0800
Message-ID: <1111183423.104571.72260@g14g2000cwa.googlegroups.com> 





Here is something a little out of the box to consider.



For the columns that are nullified over and over could you partition by
customer using a separate table for these columns that shares the PK
with the base table?  You could then truncate the partition.



HTH -- Mark D Powell --
Received on Fri Mar 18 2005 - 16:03:43 CST












Original text of this message













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