oracycles – Finding cyclic foreign keys


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.


oracycles supports the following options:


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.