Re: dba_constraints.validated

The table was bulk-reloaded a year ago and the FKs were enabled using novalidate option during a maintenance window to speed up the process but after enable novalidate the state of VALIDATED stayed as "NOT VALIDATED". I simply wonder if there is any DDL command to change it to VALIDATED.

Thanks

On Thu, Jan 7, 2016 at 4:22 PM, Rich J <rjoralist3_at_society.servebeer.com> wrote:

> On 2016/01/07 06:56, Ls Cheng wrote:
>
> 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?
>
>
> I'm struggling as to why anyone would want to do this (outside of academic
> curiosity) or why any DB engine would ever allow marking an FK as validated
> when it hasn't been.
>
> It seems that one could trace a validation to generate the SQL to hack the
> dictionary into doing this, but I hopefully don't need to explain why
> that's a terrible idea.
>
> Just my $.02,
> Rich
>
>
>

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