ORA-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.