oracycles – Finding cyclic foreign keys

Purpose

oracycles checks the foreign key references in an Oracle database for cyclic references, either direct ones (i.e. foreign keys that reference the same table) or indirect ones.

Options

oracycles supports the following options:

connectstring

An Oracle connectstring.

-v <flag>, --verbose <flag>

Produces output (on stderr) while the database is read or foreign keys are checked for cycles. (Valid flag values are false, no, 0, true, yes or 1)

-c <mode>, --color <mode>

Should the output (when the -v option is used) be colored? If auto is specified (the default) then the output is colored if it goes to a terminal. Valid modes are yes, no or auto.

--thick <flag>

If true, use oracledbs thick mode. (Valid flag values are false, no, 0, true, yes or 1)

--config_dir <directory>

In oracledbs thin mode, specify the directory that contains the tnsnames.ora file. This can be used if “Connect Descriptor Strings” from tnsnames.ora must be used but tnsnames.ora can’t be found in its default location.