DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  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

  2. #2
    Join Date
    Oct 2006
    Posts
    7
    My database is Oracle 9.2.0.6.0

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Ensure that the partitioning type of partitioned table is the same as the subpartitioning type of the composite partition.

  4. #4
    Join Date
    Oct 2006
    Posts
    7
    Hello, How I can get the partitioned type for source and bkp table??

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Oct 2006
    Posts
    7
    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.
    Attached Files Attached Files

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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;
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Oct 2006
    Posts
    7
    It's working now.

    Thanks a lot.

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