URGENT: Rebuild indexes on partitioned tables 9i w2k

  • From: Bryan Wells <bunjibry@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Jan 2005 17:55:31 -0700

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

Other related posts: