OraFAQ Forum: Performance Tuning » Movting Index partitions to differenet tablespaces.

Home » RDBMS Server » Performance Tuning » Movting Index partitions to differenet tablespaces.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Movting Index partitions to differenet tablespaces. [message #235086]

Fri, 04 May 2007 00:53

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 08:22:40 CST 2024