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 column with default value to a large table

RaunaqApr 30 2015 — edited May 5 2015

Hi ,

I am aaddng a column with a default value 0 to an existing table with rows in millions

I am on 11g

I read that the alter command does not take much time on 11g

but in my case it is still taking a lot of time , it took around 1.2 hrs yesterday.

So is there a better approach to do this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 2 2015

Added on Apr 30 2015

30 comments

15,775 views