Purpose

orareindex recreates/rebuilds all indexes and unique constraints in an Oracle database schema.

Options

orareindex supports the following options:

connectstring: An Oracle connectstring.
-v, --verbose (false, no, 0, true, yes or 1): Produces output (on stderr) while the database is read or written.
-c, --color (yes, no or auto): 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.
-x, --execute (false, no, 0, true, yes or 1): When the -x argument is given the SQL script isn't printed on stdout, but is executed directly.
-r, --rebuild (false, no, 0, true, yes or 1): If given, the script uses ALTER INDEX ... REBUILD to rebuild indexes instead of dropping and recreating them.
--format (sql or pysql): If --execute is not given, this determines the output format: Plain SQL, or PySQL which can be piped into ll.pysql.