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

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