Moving primary key index to index tablespace 1

[scohan]

Our (development) tables were created without specifying an index tablespace (although we did create the index tablespace when the DB was created.) Our QA DB was created in pretty much the same way as our dev DB, and it is now some experiencing slow response time.

For right now, there is one particlular table I'm going after. I need to specify the index tablespace for the primary key contraint. I assume that since one wasn't specified, the index was created in the data tablespace.

Can I just alter the contraint to achieve this? This table is THE base table and there are many tables related to it via FK contraints. Will I need to drop this constraints first? I don't want to lose any of the existing data. Do I need to drop all contraints and then re-add them pointing to the index tablespace?

Thanks.

 

[flstffatboy]

You can use the alter index rebuild statement and specify the new tablespace in the rebuild statement. All the constraints will remain the same when its rebuilt.

FLSTF

 

[scohan]

Thanks flstffatboy.