Home » RDBMS Server » Performance Tuning » Movting Index partitions to differenet tablespaces.
Movting Index partitions to differenet tablespaces. [message #235086] Fri, 04 May 2007 00:53 Go to next message
Messages: 3
Registered: April 2007
Location: India
Junior Member

Hi All,

I am moving a few of my index partitions to different tablespaces which has more free space. Should i rebuild the indexe(s) after the index partition move? Will the index partition move make the index unusable?

If i rename the index partition then it makes the index unusable and I need to rebuild the index. But not aware what happens when i move the index partitions.

Any quick reply is highly appreciated.

Thank you,

Re: Movting Index partitions to differenet tablespaces. [message #235156 is a reply to message #235086] Fri, 04 May 2007 03:32 Go to previous message
Messages: 48
Registered: February 2007
Move the index partition to a new tablespace with the following command:

alter index index_name rebuild partition part_name tablespace tsname;

Which means that rebuild is required

Previous Topic: Performance monitoring
Next Topic: Shared Pool Statistics - StatsPack Report
Goto Forum:

Current Time: Fri Oct 28 09:08:03 CDT 2016

Total time taken to generate the page: 0.10977 seconds