<generaterebuildindex>

<fuego : generaterebuildindex>

Description

Generates the SQL script to rebuild indexes in Oracle databases.

An SQL script is generated in order to rebuild all indexes for the specified table owners.

Example:

<fuego:generaterebuildindex
                           scriptFile="/tmp/rebuild_all.sql"
                           tmpScriptFile="/tmp/tmp_rebuild_index.sql"
                           <fuego:schema name="sch_directory"/>
                           <fuego:schema name="sch_engine"/>
                           <fuego:schema name="sch_archiving"/>
                           <fuego:schema name="sch_bam"/>
                           <fuego:schema name="sch_olap"/>
      </fuego:generaterebuildindex>

Parameters

Attribute	Description	Type	Required?
scriptfile	The location of the output script file.	File	Yes
tmpscriptfile	Sets the location of the temporary spool file that contains the alter index command for the indexes to be rebuilt.	String	Yes

Parameters accepted as nested elements

<schema>

Represents a Schema. Use as nested element of <generaterebuildindex>.

Attribute	Description	Type	Required
name	Schema name	String	Yes