Skip to Main Content

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!

estinamted time for enabling constraints

972227Apr 24 2013 — edited Apr 30 2013
Just curious, does any one know how long it would take for enabling one disabled constraint on a 166gb table? The table has 34 columns and 2 primary keys.

i did a "alter table <table_name> enable constraint <constraint_name>" and this statement has been running for 50 mins now.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2013
Added on Apr 24 2013
6 comments
341 views