Hello
What is the difference between:
CONSTAINT DISABLE VALIDATE and
CONSTAINT DISABLE NOVALIDATE ?

Does NOVALIDATE keeps indexes associated with constraint and VALIDATE
remove them ? Are there any other differences ?

Thanx
Michal