Skip to Main Content
Forums

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!

Alter table table_name move tablespace

user10745179May 19 2011 — edited May 19 2011
Hi,

Im using oracle 11.1.0.7.0 on aix 5.3 , most of the users in my database are assigned to SYSTEM tablespace, and their objects are also created in SYSTEM tablespace,

Im planning to run Alter table table_name move tablespace tablespace_name;

is there any need to run rebuild index or the above command will rebulid indexes automatically.

Thanks,
This post has been answered by rajeysh on May 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2011
Added on May 19 2011
#general-database-discussions
3 comments
4,605 views