I need to rebuild some indexes that reside within partitions. what is the syntax to find out what partition an index_a belongs to? from dba_indexes? do i need to specify owner (owner.index_a)? really, how the heck do I do this. got 5 hours. wouldnt this be right: alter index owner.index_a rebuild partition owner.partition_name please help. -- Bryan S Wells - DBA Newbie bunjibry@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l