OCI-08704
SQL assertion is enabled but failed to validate existing data.
Cause
An assertion violation occurred when SQL assertion validated existing data, the assertion state is set to ENABLE NOVALIDATE instead of ENABLE VALIDATE.
Action
Execute the ALTER ASSERTION VALIDATE DDL command for full validation. If the validation succeeds, the SQL assertion will transition to the ENABLE VALIDATE state. If it fails, the SQL assertion will remain in the ENABLE NOVALIDATE state.