OGG 分区表

1.源端

CREATE TABLE RANGETABLE  
(   
  idd   INT PRIMARY KEY ,   
  iNAME VARCHAR(10),   
  grade INT    
)   
PARTITION  BY  RANGE (grade)   
(   
      PARTITION  part1 VALUES  LESS  THAN (100) TABLESPACE  Users,   
      PARTITION  part2 VALUES  LESS  THAN (200) TABLESPACE  Users ,
      PARTITION  part3 VALUES  LESS  THAN (300) TABLESPACE  Users    
);  

2.目标端