OraFAQ Forum: Server Administration » Rebuild and Move index to another Tablespace

Home » RDBMS Server » Server Administration » Rebuild and Move index to another Tablespace (9.2.0.7; HP-UX)

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

Rebuild and Move index to another Tablespace [message #342591]

Sat, 23 August 2008 01:02

nazbrian
Messages: 36
Registered: July 2008

Member

Hi,

I have an partioned index having around 35 partitions.

Now, I want to move this index to another tablespace.

I understand I have following options,

1. Rebuild each partition at a time and move it to another tablespace.

ALTER INDEX cost_ix REBUILD PARTITION p2 TABLESPACE index_ts;

2. Drop and Re-Create in another tablespace.

Is there any other way by which I can rebuild entire index and move it to another tablespace.

Regards,
Brian.

Report message to a moderator