Skip to Main Content
Forums

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!

alter table add column performance

501151Aug 24 2006 — edited Aug 25 2006
I have a table containing few million rows. Executing the following alter table command on it takes few hours. How do I improve the performance in this case?

ALTER TABLE <table name>
ADD <column name> VARCHAR2(30) DEFAULT USER NOT NULL
ADD <column name> TIMESTAMP(6) DEFAULT SYSDATE NOT NULL
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2006
Added on Aug 24 2006
#general-database-discussions
17 comments
4,876 views