Home » SQL & PL/SQL » SQL & PL/SQL » CONSTRAINT (ENABLE VALIDATE)
CONSTRAINT (ENABLE VALIDATE) [message #194091] Wed, 20 September 2006 14:51 Go to next message
Claud
Messages: 17
Registered: July 2006
Junior Member
i've read some books, but i still confused.
can anybody tell me about the options in the data warehouse constraint.

each constraint can have :
1. ENABLE VALIDATE
2. DISABLE VALIDATE
3. ENABLE NOVALIDATE
4. DISABLE NOVALIDATE

What does it meant by each ENABLE/DISABLE AND VALIDATE/NOVALIDATE?
What about the combinations of them too?

Thanks alot.
Re: CONSTRAINT (ENABLE VALIDATE) [message #194107 is a reply to message #194091] Wed, 20 September 2006 16:46 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
It is mentioned several places in the documentation:

Fx.
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/data_int.htm#i4011

AND

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_constraints.htm#i1006697

Br
Kim
Previous Topic: date range
Next Topic: cusor ,trigger
Goto Forum:
  


Current Time: Thu Dec 08 14:44:50 CST 2016

Total time taken to generate the page: 0.07338 seconds