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)

Thaks,

My database is Oracle 9.2.0.6.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?

http://download-west.oracle.com/docs...2a.htm#2084881

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.

Thanks

PD. I've read the documentation.

Your backup table should be partitioned...

Code:

---

  PCTFREE    10
  PCTUSED    40
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  BKP_TYTAN_2005
PARTITION BY HASH (GUIDINGCPARTY_ID)
  PARTITIONS 8;

---

It's working now.

Thanks a lot.