Skip to main content

Search

Welcome to Tibero GTS!

Workaround When There Are 2 Values in PARTITION BY LIST

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 
  • Tibero supports only one PARTITION BY LIST value.
  • Oracle supports two PARTITION BY LIST values.
 
 
 

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)
)
)
;

 

 

 

 

 

Related to