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!

Enable foreign key constraint is slow

290946Nov 3 2009 — edited Nov 3 2009

Hi,

I am trying to enable a foreign key constraint using..

alter table <table name> enable constraint <fk constraint name>;

It takes a long time, in fact, it hangs. The SQL is shown to consume CPU, when seen from Oracle Enterprise Manager Top SQL page.

Is this a bug?

We have tried with and without index on the FK column(s) before enabling the FK.

Regards,
Rahul

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2009

Added on Nov 3 2009

#general-database-discussions

2 comments

1,866 views