Monday, April 23, 2012

ORA-14257: cannot move partition other than a Range or Hash partition

ORA-14257 raises because the partitions tryied to be moved are composite . When you have composite partitioning you have to move the subpartitions instead of the partitions because the row data is physically located in the subpartitions.

If you find out that the partitions point to other tablespaces than the subpartiions and you want to point to the same tablespace then you have to modify the default attributes.

alter table [table_name] modify default attributes for partition [partition_name] tablespace [tablespace_name];