ORA-14292: Partitioning type of table must match subpartitioning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-14292: Partitioning type of table must match subpartitioning

Threaded View

  1. #1
    Join Date
    Oct 2006
    Posts
    7

    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,
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width