SQL & PL/SQL

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 Tables to new tablespace

625369Feb 26 2008 — edited Feb 26 2008

Hi Folks,

I want to move some tables from one tablespace to another tablespace. I am trying to use the syntax

ALTER TABLE <TABLE NAME> MOVE TABLESPACE <TABLESPACE_NAME>

Then rebuild the indexes with syntax

alter index index_name rebuild tablespace new-tablespace.

The problem is that these tables have more than 100million records. Would that cause any issues. Would there be any problems with consistency corresponding to primary key-foreign key relationship with other tables.

Any inputs on this would be appreciated.

Thanks,
Bharath

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2008

Added on Feb 26 2008

3 comments

460 views