orareindex – Recreating indexes/constraints¶
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
<flag>
,
--verbose
<flag>
¶ Produces output (on stderr) while the database is read or written. (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 stderr is a terminal. Valid modes areyes
,no
orauto
.
-
-x
<flag>
,
--execute
<flag>
¶ When the
-x
argument is given the SQL script isn’t printed on stdout, but is executed directly in the schema specified via theconnectstring
option. (Valid flag values arefalse
,no
,0
,true
,yes
or1
)
-
-r
<flag>
,
--rebuild
<flag>
¶ If given, the script uses
ALTER INDEX ... REBUILD
to rebuild indexes instead of dropping and recreating them. (Valid flag values arefalse
,no
,0
,true
,yes
or1
)