orafind – Finding records in a schema

Purpose

orafind can be used to search all tables in an Oracle database schema for a string.

Options

orafind supports the following options:

connectstring

An Oracle connectstring.

searchstring

The text to be searched for.

tables

Zero or more tables names. If any table names are specified the search will be limited to those tables. Otherwise all tables will be searched.

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

Produces output (on stderr) while the database is read or written. (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 stderr is a terminal. Valid modes are yes, no or auto.

-i <flag>, --ignore-case <flag>

If true, the search will be case insensitve. (Valid flag values are false, no, 0, true, yes or 1)

-r <flag>, --read-lobs <flag>

If true, CLOBs will be read when printing search results. (Valid flag values are false, no, 0, true, yes or 1)

--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.

Example

Search for spam in all tables in the schema user@db. The search is case insensitive and CLOBs will be printed:

$ orafind user/pwd@db spam -i -r