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

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