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