Moving Indexes

[Mr.Hanky]

Hey people;

I have a dilema, I need to move about 2000 indexes from one tablespace to another. I can do them individually but there has to be an easier way than one at a time. Please help, Thank You

[jdorlon]

Hi Mr Hankey,

Get EZSQL. [url]http://www.ezsql.net.[/url] It can do this for you with a few clicks. (Select all of the indexes, then right-click and choose 'Create SQL to Rebuild', then fill in the options and click OK.) Even if you don't want to buy it, the trial will last 30 days and you can do it during that period.

See ya this Christmas! :-)

-John

[vinit]

Hi,
Could u tell me which version of Oracle r u using. I think u can use the rebuild index command. All u need to do is put that in a script and run.

Cheers,

[Mr.Hanky]

You guys rock!!
Thanks for the timely response. I actually posted this for a fellow DBA so I'm not sure which version he is using, or which OS.

Jdorlon, you will get xtra poo this X-Mas

[Mr.Hanky]

Ok, here is the deal. He is using Oracle 8.16 on a Solaris 8 platform. Oracle reccomends running a script, any suggestions?

Thanks Again, MH

[pando]

it's easy with sql*plus

spool rebuild_index.sql
select 'alter index '||index_name||' rebuild tablespace_idx;'
from user_indexes
/
spool off

then run rebuild_index.sql

of course this prob seems harder than a gui tool but you learn how to do it in UNIX for example