Re: B-Tree to Partitioned index

Come to think of it... now what we are on the san with these
indexes... I think there may actaully be enough room to build and then
rename the index...

Funny how sometimes you can manage to see exactly one side and as a
result one solution to the problem...

=)

thanks


On Wed, 29 Dec 2004 09:12:09 -0500, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> April,
> 
> One suggestion is to just create the new partitioned index with a different
> name.  When it is complete, drop the old one and rename the new one if you
> want it named a certain way.
> 
> Look at the ALTER INDEX RENAME command available in Oracle 9i.  If naming it
> is not the issue, then just build the new one and drop the old one.
> 
> Hope this helps!
> 
> Tom
> 
> -----Original Message-----
> From: aj wells [mailto:awellsdba@xxxxxxxxx]
> Sent: Wednesday, December 29, 2004 9:04 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: B-Tree to Partitioned index
> 
> Is there anyway to move from a "normal" b-tree index to a locally
> partitioned index online without having to to a rebuild?
> 
> We have fairly large databases (15 TB for the one that we are
> concerned with now) and we need to get one of the highest hitting
> indexes rebuilt into a partitioned index, but we have no way to do
> that elegantly when we are dumping nearly 50 GB an hour into the
> database 24 hours a day.
> 
> Suggestions?  Docs are not OVERLY helpful here...
> 
> Thanks
> aj
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: