Skip to Main Content

SQL & PL/SQL

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!

Adding a new column to a big table is very slow

user2486753Dec 22 2010 — edited Nov 9 2012
All,

I am trying to add a column to a table with defaul value as 0. The table has about 15M rows. The alter table statement is extermely slow.

I am using 11.1.0.7 on windows.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2012
Added on Dec 22 2010
13 comments
18,179 views