Re: Moving Objects to New Tablespace

What version of Oracle are you running?

In 8.1.5,

alter index <schema>.<index_name> rebuild tablespace <new_tablespace_name>;

In article <8gh98b$pd6$1_at_nnrp1.deja.com>, ctenos_at_my-deja.com wrote:
>We just added a second hard drive to our system (Sun
 E250/Sol8). Now
>that I can, I would like to move all the indexes to and INDEX
 table
>space I have created in the new HD.
>
>Is there a quick way to do this (moving the object?)? If not,
 how can
>I batch disable all the indexes and dependents and then enable
 them?
>
>Thanks!
>
>-R!
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!