Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

moving table along with constraints to another tablespace

684135Apr 9 2009 — edited Apr 9 2009
Hi,

I used alter table move tablespace command to move table to different tablespace.
But when I checked primary and foreign key constraints and indexes were showing in earlier tablespace.

How do I move them to diff tablespace along with table?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2009
Added on Apr 9 2009
5 comments
1,836 views