https://wiki.ispirer.com/ 2026-04-14T23:10:45+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/check?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CHECK to HiRDB There is no need to change Oracle CHECK. Oracle: CHECK(column <> 0) HiRDB: CHECK(column <> 0) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/default?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DEFAULT to HiRDB There is no need to change Oracle DEFAULT. Oracle: DEFAULT 10 HiRDB: DEFAULT 10 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/foreign_key_constraint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FOREIGN KEY CONSTRAINT to HiRDB If table_name is specified with schema, remove schema and add warning message “This conversion has inappropriate possibility”. If (column, column, …) is specified in referenced table's specification, remove (column, column, …) and add warning message text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/hash_partition?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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); text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/list_partition?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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); text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/not_using_partition?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NOT USING PARTITION to HiRDB Oracle: CREATE TABLE hanbai ( data_date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) TABLESPACE B1USBTBL STORAGE ( INITIAL 8000K NEXT 8000K ) PCTFREE 20 PCTUSED 60; HiRDB: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/pctfree?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle PCTFREE to HiRDB There is no need to change Oracle PCTFREE. Oracle: CREATE TABLE hanbai ( data_date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) PCTFREE 5; HiRDB: CREATE TABLE hanbai ( data_date NUMBER(8) NOT NULL, mise_no CHAR(6) NOT NULL ) PCTFREE = 5; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/range_partition?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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); text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/refer_constraint_set_default?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle REFERENTIAL CONSTRAINT with SET DEFAULT to HiRDB Add warning message “This conversion has inappropriate possibility”. Oracle: [CONSTRAINT constraint_name] REFERENCES [schema .]table_name[(column)] ON {DELETE | UPDATE} SET DEFAULT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/refer_constraint_set_null?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle REFERENTIAL CONSTRAINT with SET NULL to HiRDB Add warning message “This conversion has inappropriate possibility”. Oracle: [CONSTRAINT constraint_name] REFERENCES [schema .]table_name[(column)] ON {DELETE | UPDATE} SET NULL text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/tab_conversion/table_space?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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);