ORA-14292: Partitioning type of table must match subpartitioning
I'm trying to use ALTER TABLE EXCHANGE PARTITION OPTION for the biggest table on Oracle Database.
I created a new table "bkp_trteevents" particioned (by range) and subparticioned(by HASH).
So, then I try to to exchange particion from source table to bkp_table,
using the following command:
ALTER TABLE TRTEEVENTS EXCHANGE PARTITION P_2005_01 WITH TABLE bkp_trteevents;
And I receive the following error:
ORA-14292: Partitioning type of table must match subpartitioning type of composite partition.
I would like all help possible. (I attached ddl for bkp table)