Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: CMT8.4.1.201203
-
Fix Version/s: CMT8.4.1.201203
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
Oracle:11g
CUBRID:8.4.1.1018
CMT:8.4.1.0011
Description
When there is table which has subpartition, cannot migrate to CUBRID.
Such as:
CREATE TABLE part_range_hash(
s_productid NUMBER,
s_saledate DATE,
s_custid NUMBER,
s_totalprice NUMBER)
PARTITION BY RANGE (s_saledate)
SUBPARTITION BY HASH (s_productid) SUBPARTITIONS 8
(
PARTITION sal99q1 VALUES LESS THAN (TO_DATE('02/01/2012','DD/MM/YYYY')),
PARTITION sal99q2 VALUES LESS THAN (TO_DATE('02/02/2012','DD/MM/YYYY')),
PARTITION sal99q3 VALUES LESS THAN (TO_DATE('02/03/2012','DD/MM/YYYY')),
PARTITION sal99q4 VALUES LESS THAN (TO_DATE('02/04/2012','DD/MM/YYYY')));
CUBRID doesn't support Subpartition,so the subpartition will be lost in the migration process.