Re: moving indexes from tablespace A to B

From: Bob Yeh <tyeh_at_csc.com>
Date: 1997/05/12
Message-ID: <33778F9F.5B3A@csc.com>#1/1

fuocor_at_novachem.com wrote:
>
> I am trying to move indexes from tablespace A to tablespace B
>
> I export schema
> I drop tablespace A
> I recreate tablespace A and create tablespace B
> I import dump with indexfile option
> I edit indexfile and replace tablespace A with B
> I import dump with indexes=no option
> I run indexfile script
>

There is new command for Oracle 7(not sure when it started) to change index to another tablespace.

alter index index_name rebuild tablespace_name; Simple and quick. How wonderful this is!! Received on Mon May 12 1997 - 00:00:00 CDT