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
bunjibry@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
