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 -> Consequences of adding columns to tables ?

Consequences of adding columns to tables ?

From: Spendius <spendius_at_muchomail.com>
Date: 30 Aug 2005 00:36:22 -0700
Message-ID: <1125387382.433599.63270@g14g2000cwa.googlegroups.com>


Hello,
What do you think can be the consequences of spending your time adding fields to existing tables ?
We have several apps here where developers regularly send requests to modify tables structures, kind of: ALTER TABLE <..> ADD COLUMN X
UPDATE <..> SET x = '<def. value>'
ALTER TABLE <..> MODIFY (x DEFAULT VALUE '<def. val.>')

What are the effects in the blocks ? Do records not end up having chained/migrated rows all over the place ?

What do you think ?
Thanks.
Spendius Received on Tue Aug 30 2005 - 02:36:22 CDT

Original text of this message

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