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 taking too long

DBA112Jun 10 2014 — edited Jun 11 2014

Dear DBA friends,

I'm running below alter statement, thats been running over 2 hours. The table has 119 million rows.

Any idea why adding a column is taking such a long time on this table? Is there a way to expedite this?

ALTER TABLE COMPOSITE ADD ATTRIBUTE NUMBER(18, 0) DEFAULT -1

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2014

Added on Jun 10 2014

#general-database-discussions

6 comments

4,168 views