I have noticed that when I change PK of the table A from deferrable to not deferrable in PL/SQL Developer (table tab Keys checkbox Deferrable), FK constraints of different tables referring to table A dissapear.
The same happens when switch PK from not deferrable to deferrable. Is it Oracle or PL/SQL Developer deficiency? It looks pretty serious...
PL/SQL Developer - 7.1.2.1363
Oracle - 10.2.0.3.0
OS - Winsdows XP Professional - SP2
The same happens when switch PK from not deferrable to deferrable. Is it Oracle or PL/SQL Developer deficiency? It looks pretty serious...
PL/SQL Developer - 7.1.2.1363
Oracle - 10.2.0.3.0
OS - Winsdows XP Professional - SP2