-
Are ther any consequences when you disable a
"DISABLE VALIDATE" CONSTRAINT
then load a huge data into a partition table.
After the load,then re-enable the constraint?
What are the costs associated with doing this?
-
It should be the best solution for loading data into partitioned table, provided it is not
a child table.
-
Also if it does not violate any constraints, else re-enabling them won't be possible.
Vinit
-
You can re-enable by using exceptions table or if u are certain that there are no
duplicates and you have millions of rows that would cause a lot of time to enable
the unique key then use rely option of enabling constraint which shall force Oracle
to believe that everything is ok .For rely u have to enable query_rewrite parameter in init.ora.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|