Re: moving indexes to new tablespace

Richard Fuoco wrote:
>
> hi, i am trying to move indexes from tablespace A to tablespace B
> I do an export of the schema that I want to reorg and move the indexes
> I drop the tablespace with contents
> I recreate the tablespace A and create a new tablepsace B
> I run imp with the indexfile option to create a sql file with all the
> create index commands.
> I modify this file and replace the tablespace A with B
> I import the dmp file with the indexes=no option
> I run the script to create the indexes in new tablespace B
>
> The problem is that any indexes that are created from a primary key
> constraint still goes into tablespace A. The dump file contains alter
> table commands to create the primary constraint
>
> Is there a way to move these primary key constraints (indexes) to
> tablespace B without writing all the scripts to drop and recreate. Or
> does anyone have a sql statement to build the scripts from the data
> dictionary.
>
> Any help would be appreciated
>
> Regards
> Richard Fuoco
> fuocor_at_novachem.com

You may try 'alter index <index> rebuild tablespace <new tablespace>', if you are working with 7.3. Received on Thu Aug 14 1997 - 00:00:00 CDT