dba_constraints.validated

From: Ls Cheng <exriscer_at_gmail.com>
Date: Thu, 7 Jan 2016 13:56:52 +0100
Message-ID: <CAJ2-Qb-59ixyGo=ko3F0j=JRw+9AqOX0phygbcZHY7QygT9_-g_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 07 2016 - 13:56:52 CET

This message: [ Message body ]
Next message: Chris Taylor: "PSU question when using RAC"
Previous message: Tim Hall: "Re: Oracle XE 12c ?"
Next in thread: Ls Cheng: "Re: dba_constraints.validated"
Maybe reply: Ls Cheng: "Re: dba_constraints.validated"
Maybe reply: Mikhail Velikikh: "Re: dba_constraints.validated"
Maybe reply: Franck Pachot: "Re: dba_constraints.validated"
Maybe reply: Ls Cheng: "Re: dba_constraints.validated"
Maybe reply: Ls Cheng: "Re: dba_constraints.validated"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message