dba_constraints.validated

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 7 Jan 2016 13:56:52 +0100

Hi

I have some tables whose FK in dba_constraints.validated appears as "NOT
VALIDATED". I guess it's because it was once enabled using novalidate
clause.

Is it possible to "change" this to VALIDATED without validating the
constraints?


TIA

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2016