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

Home -> Community -> Mailing Lists -> Oracle-L -> Add column(s) to an existing table

Add column(s) to an existing table

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Tue, 1 Aug 2006 16:49:33 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7095E75DC@irv2kexch01.tx.bg.corp>


Hi List,

Does the following SQL touch every single row immediately?

ALTER TABLE supplier
ADD (supplier_tax_id varchar2(10),

            supplier_timezone varchar2(5) );

What is the best way to add column(s) to an existing table with millions of rows?

Thanks,

Roger

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o



This email has been scanned for all viruses by the MessageLabs Email Security System.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 01 2006 - 16:49:33 CDT

Original text of this message

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