Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle RANGE PARTITION to HiRDB
Oracle Range Partition changed to its equivalent in HiRDB.
Oracle:
CREATE TABLE hanbai ( data_date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) PARTITION BY RANGE (data_date) (PARTITION d1 VALUES LESS THAN (10) TABLESPACE TBS01, PARTITION d2 VALUES LESS THAN (20) TABLESPACE TBS02, PARTITION d3 VALUES LESS THAN (MAXVALUE) TABLESPACE TBS03);
HiRDB:
CREATE TABLE hanbai ( data_date INTEGER NOT NULL, mise_no CHAR(6) NOT NULL ) IN ((TBS01) data_date < 10, (TBS02) data_date < 20, (TBS03));