Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle MATERIALIZED VIEW to HiRDB
Remove “OR REPLACE”.Add warnning message “Could not convert 'MATERIALIZED VIEW'”.
Oracle:
CREATE OR REPLACE MATERIALIZED VIEW view01 (C1, C2, C3) AS SELECT C1,C2,C3 FROM table1 ;
HiRDB:
CREATE VIEW view01 (C1, C2, C3) AS SELECT C1,C2,C3 FROM table1 ; /*Could not convert 'MATERIALIZED VIEW'*/