RE: B-Tree to Partitioned index

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 Received on Wed Dec 29 2004 - 08:07:33 CST