Please visit for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

March 8, 2011

10g vs 11g add a column with not null default value

Filed under: Uncategorized — orawiss @ 12:31 pm

Prior to Oracle database 11g, adding a new column with a default NOT NULL value were a challenge. Especially, when the concerned table contains thousands or millions of records. Oracle 10g updates ALL the rows of the concerned table with the new default value. In my busy real time OLTP databases, I had to create another intermediate table with the same structure plus the new default not null column. This solution needs a switch to the second table and a rename table operation.
As you can Imagine, this solution takes time, resources, space, loads, locks.
Oracle database 11g offers a new quick, easy, instant solution; instead of updating ALL the rows of the table, Oracle 11g now updates the metadata only.

Read the complete article here:


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: