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
kp_prasanth
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,

Prasanth

Report message to a moderator

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
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
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

Thanks

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 06:33:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.