OCI-08673
Equijoin string found does not meet the criteria to do a FAST validation.
Cause
One of the columns in the equijoin either lacks a NOT NULL property or the data types do not match.
Action
Consider adding a NOT NULL constraint to the column or including the predicate, col IS NOT NULL in the assertion definition within the query block where the table is referenced. For example: CREATE ASSERTION AS1 CHECK ( NOT EXISTS(select 1 from t1 where t1.c1 is NOT NULL and NOT EXISTS(select 1 from t2 where t1.c1 = t2.c2 and t2.c2 is NOT NULL)) Also, ensure that the column data types are identical. For example, ensure that the data type of columns t1.c1 and t2.c2 are the same.