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


=================================
def ``main``​(``args``=``None``):
=================================