在Oracle 11g2中交换子分区分区

我有两个表，具有相同的分区和子分区，填充了一些虚拟数据：

CREATE TABLE TEST_TBL_1(col_1 number, col_2 number, col_3 number, col_4 number ,col_5 VARCHAR2(100))
  PARTITION BY RANGE (col_1, col_2, col_3)
  SUBPARTITION BY RANGE (col_4)
(
  PARTITION PDUMMY
    VALUES LESS THAN (-1, -1, -1)
    ( SUBPARTITION SPDUMMY VALUES LESS THAN (-1)),
  PARTITION P_1_1_1
    VALUES LESS THAN (1, 1, 1)
    ( SUBPARTITION SP_1_1_1_1000 VALUES LESS THAN (1000),
      SUBPARTITION SP_1_1_1_2000 VALUES LESS THAN (2000),
      SUBPARTITION SP_1_1_1_3000 VALUES LESS THAN (3000)),
  PARTITION P_2_2_2
    VALUES LESS THAN (2, 2, 2)
    ( SUBPARTITION SP_2_2_2_1000 VALUES LESS THAN (1000),
      SUBPARTITION SP_2_2_2_2000 VALUES LESS THAN (2000),
      SUBPARTITION SP_2_2_2_3000 VALUES LESS THAN (3000)));

CREATE TABLE TEST_TBL_2(col_1 number, col_2 number, col_3 number, col_4 number ,col_5 VARCHAR2(100))
  PARTITION BY RANGE (col_1, col_2, col_3)
  SUBPARTITION BY RANGE (col_4)
(
  PARTITION PDUMMY
    VALUES LESS THAN (-1, -1, -1)
    ( SUBPARTITION SPDUMMY VALUES LESS THAN (-1)),
  PARTITION P_1_1_1
    VALUES LESS THAN (1, 1, 1)
    ( SUBPARTITION SP_1_1_1_1000 VALUES LESS THAN (1000),
      SUBPARTITION SP_1_1_1_2000 VALUES LESS THAN (2000),
      SUBPARTITION SP_1_1_1_3000 VALUES LESS THAN (3000)),
  PARTITION P_2_2_2
    VALUES LESS THAN (2, 2, 2)
    ( SUBPARTITION SP_2_2_2_1000 VALUES LESS THAN (1000),
      SUBPARTITION SP_2_2_2_2000 VALUES LESS THAN (2000),
      SUBPARTITION SP_2_2_2_3000 VALUES LESS THAN (3000)));


INSERT INTO TEST_TBL_1(col_1, col_2, col_3, col_4, col_5) values (1,1,0,500,  'TABLE 1: Partition P_1_1_1 subpartition SP_1_1_1_1000');
INSERT INTO TEST_TBL_1(col_1, col_2, col_3, col_4, col_5) values (1,1,0,1300, 'TABLE 1: Partition P_1_1_1 subpartition SP_1_1_1_2000');
INSERT INTO TEST_TBL_1(col_1, col_2, col_3, col_4, col_5) values (1,1,0,2700, 'TABLE 1: Partition P_1_1_1 subpartition SP_1_1_1_3000');
INSERT INTO TEST_TBL_1(col_1, col_2, col_3, col_4, col_5) values (1,1,0,2990, 'TABLE 1: Partition P_1_1_1 subpartition SP_1_1_1_3000');


INSERT INTO TEST_TBL_2(col_1, col_2, col_3, col_4, col_5) values (1,1,0,700,  'TABLE 2: Partition P_1_1_1 subpartition SP_1_1_1_1000');
INSERT INTO TEST_TBL_2(col_1, col_2, col_3, col_4, col_5) values (1,1,0,1500, 'TABLE 2: Partition P_1_1_1 subpartition SP_1_1_1_2000');
INSERT INTO TEST_TBL_2(col_1, col_2, col_3, col_4, col_5) values (1,1,0,2222, 'TABLE 2: Partition P_1_1_1 subpartition SP_1_1_1_3000');
INSERT INTO TEST_TBL_2(col_1, col_2, col_3, col_4, col_5) values (1,1,0,2323, 'TABLE 2: Partition P_1_1_1 subpartition SP_1_1_1_3000');

我的目标是将表1中的分区与表2中的相应分区交换，包括所有子分区数据 . 但是如果我使用交换分区语法：

ALTER TABLE test_tbl_1
EXCHANGE PARTITION P_1_1_1
WITH TABLE test_tbl_2 ;

我最终会得到一个错误：

ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

有没有办法在一个语句中交换这些表之间的分区？如果不是，请您指导我一步一步完成这项工作的最有效方法吗？

谢谢 .