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)
My database is Oracle 18.104.22.168.0
Ensure that the partitioning type of partitioned table is the same as the subpartitioning type of the composite partition.
Hello, How I can get the partitioned type for source and bkp table??
you mean u did not compare the descriptions of the 2 tables?
can you print both dear?
Behind The Success And Failure Of A Man Is A Woman
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.
DDL for bkp_table will be (db.txt).
My bkp table is created from PARTITION P_2005_01.
PD. I've read the documentation.
Your backup table should be partitioned...
PARTITION BY HASH (GUIDINGCPARTY_ID)
It's working now.
Thanks a lot.
Click Here to Expand Forum to Full Width