Re: moving indexes to new tablespace

 Or, if you are on 7.3 or higher simply...

SQL> alter index INDEXNAME rebuild tablespace NEW_TABLESPACENAME;

Oracle_man wrote in article <3415A8CA.5A79_at_msn.com>...

>You should be able to disable contraints while up and open. Drop said
>index, and re-create index specifying proper tablespace.
>
>rich
>
>
>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
Received on Wed Sep 10 1997 - 00:00:00 CDT