rebuilding table / index partitions
I am working on an Oracle 10.2.0.4 database on Solaris 5.10 (upgrade to 11g being planned). An ADDM report (actually, more than just one report) has recommended increasing the INITRANS on several partitions of a certain table. This table has three nonpartitioned indexes and two partitioned indexes. One of those two partitioned indexes is a text index. I know that "ALTER TABLE table_name MOVE PARTITION partition_name TABLESPACE tablespace_name INITRANS nn PCTFREE nn" will cause indexes on table to be invalidated. For the nonpartiioned indexes, just running "ALTER INDEX index_name REBUILD" takes care of the issue, but what about the partitioned
2