|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
integrity constraint: DISABLE VALIDATE
in oracle 9i documentation i have read that DISABLE clause can be:
DISABLE NOVALIDATE (default. i understand vat it means) or DISABLE VALIDATE: disables the constraint and drops the index on the constraint, but keeps the constraint valid. This feature is most useful in data warehousing situations, because it lets you load large amounts of data while also saving space by not having an index. All other modifications to the table (inserts, updates, and deletes) by other SQL statements are disallowed. question1 if this means that data which violates the constraint is not allowed in the table, then vat is the difference between disable validate and an enabled constraint? question2 is this only a 9i feature or is it available in oracle8 as well? because i dont find it in my oracle8 book (which we r following in school) |
|
#2
|
||||
|
||||
|
In short:
Quote:
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
Quote:
im sorry i must be particularly dense coz i still dont get it. vat does it mean by keeping the constraint valid? also, is this only a 9i feature? |
|
#4
|
||||
|
||||
|
question 1:
Quote:
It basically means that the index used to enforce the constraint is dropped and you can not modify the table data. It's used to freeze the table for: Quote:
question2: No, the feature is available in 8i also. Last edited by pabloj : April 28th, 2005 at 04:24 AM. |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > integrity constraint: DISABLE VALIDATE |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|