Ispirer Migration Knowledge Base sqlways:oracle:conversions:hirdb:index_conversion
https://wiki.ispirer.com/
2026-04-14T20:17:29+00:00Ispirer Migration Knowledge Base
https://wiki.ispirer.com/
https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.icotext/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle ASC to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/asc?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle ASC to HiRDB
There is no need to change Oracle ASC.
Oracle:
ASC
HiRDB:
ASCtext/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle BITMAP INDEX to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/bitmap_index?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle BITMAP INDEX to HiRDB
Remove BITMAP. Add warning message “This conversion has inappropriate possibility”.
Oracle:
BITMAP
HiRDB:
/*This conversion has inappropriate possibility*/text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle CLUSTER INDEX to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/cluster_index?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle CLUSTER INDEX to HiRDB
There is no equivalent of Oracle CLUSTER.Add Warning Message “Could not convert 'CLUSTER INDEX'”.
Oracle:
CLUSTER
HiRDB:
/*Could not convert 'CLUSTER INDEX'*/text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle DESC to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/desc?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle DESC to HiRDB
There is no need to change Oracle DESC.
Oracle:
DESC
HiRDB:
DESCtext/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle LOCAL to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/local?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle LOCAL to HiRDB
Remove LOCAL.
Oracle:
LOCAL
No Equivalent in HiRDB.text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle PCTFREE to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/pctfree?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle PCTFREE to HiRDB
Equivalent in HiRDB is PCTFREE.
Oracle:
CREATE unique INDEX IX1
ON HANBAI_D ( mise_no DESC, shohin ASC, shohin2)
PCTFREE 05
TABLESPACE TBS_USIA_IX_10000K;
HiRDB:
CREATE unique INDEX IX1
ON HANBAI_D
(mise_no DESC,
shohin ASC,
shohin)
IN( TBS_USIA_IX_10000K)
PCTFREE=5;text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle PCTUSED to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/pctused?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle PCTUSED to HiRDB
There is no equivalent of Oracle PCTUSED in HiRDB.Remove PCTUSED.
Oracle:
PCTUSED
No Equivalent in HiRDB.text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle STORAGE to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/storage?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle STORAGE to HiRDB
There is no equivalent of STORAGE in HiRDB.Remove STORAGE.
Oracle:
STORAGE
No Equivalent in HiRDB.text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle TABLE SPACE to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/table_space?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle TABLE SPACE to HiRDB
Remove “TABLESPACE”.
Oracle:
CREATE INDEX IX1
ON HANBAI_D ( mise_no,shohin )
TABLESPACE TBS_USIA_IX_10000K
LOCAL
;
HiRDB:
CREATE INDEX IX1
ON HANBAI_D ( mise_no,shohin )
IN( TBS_USIA_IX_10000K)
;text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle UNIQUE INDEX to HiRDB
https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/index_conversion/unique_index?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle UNIQUE INDEX to HiRDB
There is no need to change Oracle UNIQUE INDEX.
Oracle:
UNIQUE INDEX
HiRDB:
UNIQUE INDEX