Re: Moving Objects to New Tablespace

THANK YOU!!!!!!! -R!

In article <020e0f0c.59ecd7a2_at_usw-ex0102-014.remarq.com>,   suzilem <suzilemNOsuSPAM_at_aol.com.invalid> wrote:
> 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!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri May 26 2000 - 00:00:00 CDT