Re: Consequences of adding columns to tables ?

On 30 Aug 2005 00:36:22 -0700, "Spendius" <spendius_at_muchomail.com> wrote:

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

Not when pctfree has been set up appropiately. And you could easily *proof* chaining.
The only impact is that trailing null columns will no longer have zero length. And that is all.
The consequences for the datamodel when columns are added on the fly are far more dramatic.

--
Sybrand Bakker, Senior Oracle DBA