How to move partitioned table to new tablespace
I need to move partitioned table to a new tablespace without re-creating it. The table is range partitioned having 20 partitions. I can move all the partitions using 'alter table move partition..' command..but when I try to execute 'alter table <table_name> move tablespace <tablespace_name>' I am getting:
"ORA-14511: cannot perform operation on a partitioned object"
Is there any way to move the table to new tablespace.
"ORA-14511: cannot perform operation on a partitioned object"
Is there any way to move the table to new tablespace.
0