ora-14257 for table with subpartions - when attempting to move the partitions
I am receiving an ora-14257 when I attempt to move a partition. The table has subpartitions and I was able to move them successfully to another
tablespace. However, dba_tab_partitions list the partitions in the original tablespace. I want to change that tablespace and I cannot move the partition.
It is a range partition
Example; alter table CLARITY_USER.ORDER_PROC move partition P1 tablespace clarity_tables ; --this recieves an ora-14257
Is is possible to change the partition's tablespace after I changes the subpartition tablespaces. We are planning to remove the
original tablespace
Thank you
06/23/09 - Looks like I will have to exp/drop/create/imp the partition because the subpartitions are arranged by HASH and the partition
It is a range partition
Example; alter table CLARITY_USER.ORDER_PROC move partition P1 tablespace clarity_tables ; --this recieves an ora-14257
Is is possible to change the partition's tablespace after I changes the subpartition tablespaces. We are planning to remove the
original tablespace
Thank you
06/23/09 - Looks like I will have to exp/drop/create/imp the partition because the subpartitions are arranged by HASH and the partition
0