Please visit www.oracle-class.com 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

Introduction:
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: www.oracle-class.com

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: