Oracle Error Codes

Join index must only contain inner equi-joins

Join index cannot be a functional index

Missing primary key or unique constraint on dimension

All tables must be joined in the where clause

Join index cannot be created on tables owned by SYS

Join index where clause cannot contain cycles

Join index where clause predicate may only contain column references

Join index must be of the bitmap type

Join index cannot be based on a temporary table

Join index prevents dml cascade constraint operation