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!

How to Disable constraint on a table at partition level

999670Aug 11 2015 — edited Aug 11 2015

Hi ,

I want to load huge data into a particular partition of a table.

During load i want to disable constraints on the particular partition of the table which i am currently loading.

I don't want to disable constraint on whole table and enable it later .. as it may take more time ...

Similar to the way we can mark index of a particular partition 'UNUSABLE' during a bulk load , is it possible to do the same for constraints also ?

This post has been answered by Dom Brooks on Aug 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2015
Added on Aug 11 2015
5 comments
1,149 views