Hi,
i am using 11.2.0.3.0 version of oracle. I am planning to move a composite partition(range-hash) table into a different tablespace. And i was under assumption by moving the table/index subpartition , it will move the wholw table. Below is the scenario.
Now i have moved all the table/Index subpartition into the new tablespace, using below command.
Alter table t1 move subpartition t1_sub1 tablespace new_tablespace;
Alter index id1 rebuild subpartition id1_sub1 tablespace new_ind1_tablespace;
but when i query dba_tab_subpartition i can see the new tablespace against the subpartition name but when i query the data dictionary dba_tab_partitions i am seeing the name of old tablespace against the partition name. And i execute below statement for moving the partition
Alter table t1 move partition t1_p1 tablespace new_tablespace;
It gives error saying : ORA-14257: cannot move partition other than a range,list,system or hash partition.