Hi,
We are looking to add column (new measure) to some large tables (over a a billion rows)
This is a partitioned table - guess can still use alter table and won't invalidate indexes etc and the alter table command will execute quickly?
Is this a correct assumption?
Also with regards space notice the columns on table defined as NUMBER with no actual size.
Is it correct in ORACLE
Values stored in a NUMBER column take up only as much space as needed?
Thanks