Database Error Messages

OCI-11536

cannot validate (constraint_schema.constraint_name) involving column_names due to domain constraint domain_constraint_schema.domain_constraint_name of domain domain_schema.domain_name - check constraint violated
  • constraint_schema: The schema name where the constraint resides.
  • constraint_name: The name of the constraint.
  • column_names: The column names involved in the constraint. A subset of the column names if the list is too long.
  • domain_constraint_schema: The schema name where the domain constraint resides.
  • domain_constraint_name: The name of the domain constraint the constraint is inherited from.
  • domain_schema: The schema name where the domain resides.
  • domain_name: The name of the domain.

Cause

An alter table operation tried to validate a check constraint inherited from a domain to a populated table that had non-complying values.


Action

Do not insert values that violate the constraint or disassociate the columns from the named domain.