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>
| Attribute | Description | Type | Required? |
| scriptfile | Sets the location of the output script file. | File | ? |
| tmpscriptfile | Sets the location of the temporary spool file that contains the alter index command for the indexes to be rebuilt. | String | ? |
| Attribute | Description | Type | Required |
| name | String | ? |