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'*/

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