Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle HASH PARTITION to HiRDB
Oracle Hash Partition changed to HiRDB Hash Partition according its syntax.
Oracle:
CREATE TABLE hanbai ( data_date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) PARTITION BY HASH (data_date, mise_no) (PARTITION p1 TABLESPACE TBS01, PARTITION p2 TABLESPACE TBS02);
HiRDB:
CREATE TABLE hanbai ( data_date INTEGER NOT NULL, mise_no CHAR(6) NOT NULL ) FIX HASH HASH6 BY data_date, mise_no in(TBS01,TBS02,TBS03);