Document Type | Technical Information
Category | Migration
Applicable Product Versions | 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document Number | TMITI008
Overview
In Tibero, the PARTITION BY LIST syntax currently does not support specifying two or more values for a single partition.
If this feature is needed, we provide guidance on feature development and how to handle it with a workaround.
Note
Method
Modify it to a subpartition form as a workaround.
- Before Change
create table t ( c1 number, c2 number, c3 number, c4 number ) partition by list (c1,c2) ( partition t_p1 values (1,1), partition t_p2 values (1,2), partition t_p3 values (2,1), partition t_p4 values (2,2) ) ;
- After Change
create table t ( c1 number, c2 number, c3 number, c4 number ) partition by list (c1) subpartition by list (c2) ( partition t_p1 values (1) ( subpartition t_p1_sp1 values (1), subpartition t_p1_sp2 values (2) ), partition t_p2 values (2) ( subpartition t_p2_sp1 values (1), subpartition t_p2_sp2 values (2) ) ) ;