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!

Alter table taking more time to add new column(FLG char(1))(5 Bilion recor

cool_oraNov 7 2012 — edited Nov 7 2012

Hi friends,

I am trying to add new column FLG char(1) default N not null to one table through ALTER command
1.Table containing 5 Billion records,
2.*Partitioned table*, also having primary key..

The problem here it is taking more than 40 hours for alter this table.

How can I speed up this process.
Can I disable the constraint?( would it be the correct solution )
Plz help me..........

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2012

Added on Nov 7 2012

#performance, #pl-sql, #plsql, #query, #sql, #table

8 comments

2,287 views