Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle TABLE SPACE to HiRDB
Remove “TABLESPACE”.
Oracle:
CREATE TABLE hanbai ( data_ date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) PARTITION BY RANGE (data_date) (PARTITION d19970101 VALUES LESS THAN (19970102) TABLESPACE TBS_USIA_10000K);
HiRDB:
CREATE TABLE hanbai ( data_date INTEGER NOT NULL, mise_no CHAR(6) NOT NULL ) IN ((TBS_USIA_10000K) data_date < 19970102);