ORA-14292: Partitioning type of table must match subpartitioning
Hello,
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)
Sorry, maybe I didn't explain my problem properly.
Using a third party software, I just Extract a DDL for source table (It's atacched to this comment, TRTEEVENTS_ORG_DDL.txt)
Then the only partition on wich I am interested is Partition P_2005_01 on the source table, so I created a new bkp_table using the DDL from source table only for this partition.