Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle LIST PARTITION to HiRDB
Oracle Partition By List is changed to the equivalent according to the HiRDB syntax.
Oracle:
CREATE TABLE hanbai ( data_date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) PARTITION BY LIST (data_date) (PARTITION d1 VALUES(10,20,30) TABLESPACE TBS01, PARTITION d2 VALUES(40,50,60) TABLESPACE TBS02);
HiRDB:
CREATE TABLE hanbai ( data_date INTEGER NOT NULL, mise_no CHAR(6) NOT NULL ) IN((TBS01) data_date = (10,20,30), (TBS02) data_date=(40,50,60))