Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add new column on 25 Million rows Table

792819Mar 17 2011 — edited Mar 17 2011

Hi Gurus,

I have to add new column to a application table that get's populated with each Transaction.
Can we do this with zero Downtime and what are the things i need to look in after adding it from the performance point.
One thing that come's to my mind is re-run the stats

Any Suggestion

Database version= 10.2.0.4
OS=RHEL4

I appreciate your help on this
Thanks

This post has been answered by orawiss on Mar 17 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2011

Added on Mar 17 2011

#general-database-discussions

10 comments

1,774 views