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:
- -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
or1
)
- -c <mode>, --color <mode>
Should the output (when the
-v
option is used) be colored? Ifauto
is specified (the default) then the output is colored if it goes to a terminal. Valid modes areyes
,no
orauto
.
- --thick <flag>
If true, use
oracledb
s thick mode. (Valid flag values arefalse
,no
,0
,true
,yes
or1
)
- --config_dir <directory>
In
oracledb
s thin mode, specify the directory that contains thetnsnames.ora
file. This can be used if “Connect Descriptor Strings” fromtnsnames.ora
must be used buttnsnames.ora
can’t be found in its default location.