DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: constraint issue

  1. 11-15-2001, 04:23 PM #1
    oracleman
    oracleman is offline Junior Member
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Post

    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?
    Reply With Quote Reply With Quote
  2. 11-16-2001, 11:20 AM #2
    gpsingh
    gpsingh is offline Senior Member
    Join Date
    Feb 2001
    Posts
    389
    It should be the best solution for loading data into partitioned table, provided it is not
    a child table.
    Reply With Quote Reply With Quote
  3. 11-16-2001, 11:41 AM #3
    vinit
    vinit is offline Senior Member
    Join Date
    Oct 2000
    Posts
    467
    Also if it does not violate any constraints, else re-enabling them won't be possible.
    Vinit
    Reply With Quote Reply With Quote
  4. 11-16-2001, 11:49 AM #4
    gpsingh
    gpsingh is offline Senior Member
    Join Date
    Feb 2001
    Posts
    389
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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