User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
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))