Home » RDBMS Server » Server Administration » Rebuild and Move index to another Tablespace (9.2.0.7; HP-UX)
Rebuild and Move index to another Tablespace [message #342591] Sat, 23 August 2008 01:02 Go to next message
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.
Re: Rebuild and Move index to another Tablespace [message #342595 is a reply to message #342591] Sat, 23 August 2008 01:23 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can use first option(rebuild) for that you can create custom SQL script which rebuild all index partition in one shot.

Previous Topic: ora-01652
Next Topic: how do i drop tablespace that there datafiles has been dropped
Goto Forum:
  


Current Time: Wed Dec 07 11:04:46 CST 2016

Total time taken to generate the page: 0.13488 seconds