Re: dba_constraints.validated
- From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 07 Jan 2016 09:22:48 -0600
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
Other related posts: