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_at_labor.state.ny.us> 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_at_gmail.com]
> Sent: Wednesday, December 29, 2004 9:04 AM
> To: oracle-l_at_freelists.org
> 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