Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle LIST PARTITION to HiRDB

Oracle Partition By List is changed to the equivalent according to the HiRDB syntax.

Oracle:

CREATE TABLE hanbai
     ( data_date NUMBER(8) NOT NULL,
        mise_no CHAR(6) NOT NULL
      )
PARTITION BY LIST (data_date)
(PARTITION d1 VALUES(10,20,30)
TABLESPACE TBS01,
PARTITION d2 VALUES(40,50,60)
TABLESPACE TBS02);

HiRDB:

CREATE TABLE hanbai 
( 
 data_date INTEGER NOT NULL, 
 mise_no CHAR(6) NOT NULL 
) 
IN((TBS01) data_date = (10,20,30), 
  (TBS02) data_date=(40,50,60))

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