Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> URGENT: Rebuild indexes on partitioned tables 9i w2k

URGENT: Rebuild indexes on partitioned tables 9i w2k

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Tue, 4 Jan 2005 17:55:31 -0700
Message-ID: <b78d5a200501041655482b35cc@mail.gmail.com> 





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_at_gmail.com


--



http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 04 2005 - 18:54:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US