April 26th, 2005, 11:48 PM
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
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)
April 27th, 2005, 03:19 AM
April 27th, 2005, 10:18 PM
im sorry i must be particularly dense coz i still dont get it. vat does it mean by keeping the constraint valid?
Originally Posted by cherry1
also, is this only a 9i feature?
April 28th, 2005, 03:11 AM
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:
as you can read here which is also an example of the official docs coming with Oracle.
No, the feature is available in 8i also.
Last edited by pabloj; April 28th, 2005 at 03:24 AM.