OCI-40547
cannot set the precheck state for a non CHECK constraint
Cause
The specified constraint is not a CHECK constraint. Only CHECK constraints can be set to one of the two precheck states: PRECHECK or NOPRECHECK.
Action
Select another constraint that is a CHECK constraint and retry the statement.