RE: B-Tree to Partitioned index

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'awellsdba@xxxxxxxxx'" <awellsdba@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 29 Dec 2004 09:12:09 -0500


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!


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


Other related posts: