Online Documentation for SQL Manager for Oracle
Setting foreign key options
Use the Options tab of Foreign Key Editor to specify the foreign key constraint options.
Status
Use this group to toggle the constraint status:
Disabled (disables the integrity constraint)
Enabled (applies the constraint to the data in the table or view)
Validation
Options of this group correlate with the corresponding server constraint behaviour parameters - VALIDATE and NOVALIDATE:
No validate (ensures that all new DML operations on the constrained data comply with the constraint)
Validate (specifies that all old and new data also complies with the constraint)
Deferrable
Select this option to enable the deferrable group which allows you to specify one of the following:
Initially immediate (indicates that Oracle should check this constraint at the end of each subsequent SQL statement)
Initially deferred (indicates that Oracle should check this constraint at the end of subsequent transactions)
Rely
Use this group to specify whether a constraint in NOVALIDATE mode is to be taken into account for query rewrite:
No rely
Rely (activate an existing constraint in NOVALIDATE mode for query rewrite in an unenforced query rewrite integrity mode)
Note: This group is only available on editing an existing foreign key constraint.
Exceptions processing
This group lets you define exception handling, i.e. specify a table into which Oracle places the rowids of all rows violating the foreign key constraint. Use the Schema and Table or view drop-down lists to specify the table into which exceptions will be stored.