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));

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.