You are here

Tech Team's blog

If you want to enable or disable all constraints which is normally done in datawarehousing jobs you are likely to get two errors ORA-02270: no matching unique or primary key for this column-list or ORA-02297 cannot disable constraint (SYS_C0010965) - dependencies.

To avoind this you should enable or disable constraint in a order. To disable all constraints use "order by constraint_type desc" ie. disable foreign ket first and then Primary key. Likewise if you are enabling do it in reverse order. for eg. "order by constraint_type"