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