Database DataWarehousing (MOSC)

MOSC Banner

rebuilding table / index partitions

edited Jun 18, 2013 3:07AM in Database DataWarehousing (MOSC) 9 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center