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!

partitioned table move

J1604Oct 22 2008 — edited Oct 22 2008

Hi
I have a partitioned table and want to move into other schema.
I have tried command to do that on sql> prompt

alter table table_name move tablespace new_tablespace;

gave me an error
SQL Error: ORA-14511: cannot perform operation on a partitioned object

what is the workaround to move this table to new tablespace ?
any advise will be helpful,
Thanks
JP

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2008

Added on Oct 22 2008

3 comments

112 views