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