Materialized View and Reduced Precision /DMS-34050
SCO does not consistently extract properties of MV for creation scripts.
The use of REFRESH with specific timestamp is a separate issue.
Here i concentrate on 1 other error around the 'WITH REDUCED PRECISION' clause.
on RHS DB I can extract the MV with dbms_metadata with
select dbms_metadata.get_ddl('MATERIALIZED_VIEW', 'MV_FYSRAP_BEH', 'H6601') from dual
CREATE MATERIALIZED VIEW "H6601"."MV_FYSRAP_BEH" ("ID", "RAPPORTNAVN", "FORMAT", "LOGONIDFAST", "BES_ID", "STATUS", "SYNLIGHED", "LOGONID", "AJOURTID", "BEHANDLER_ID2", "DYR_ID", "DRIFTSENH_ID") ON PREBUILT TABLE WITH REDUCED PRECISION USING INDEX REFRESH FORCE ON DEMAND START WITH sysdate+0 NEXT SYSDATE+30/(24*60*60) WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE AS select id, rapportnavn, format, logonidfast, bes_id, status, synlighed, logonid, ajourtid, behandler_id2, dyr_id, driftsenh_id from fysiskrapport where behandler_id2 is not null and synlighed <> 0
This demonstrate that the 'WITH REDUCED PRECISION' is present at the RHS DB but for some reason SCO does not reflect that in the extracted script.
Also I note that the column aliasing clause of the SCO script is absent. I have not checked what would happen if it actually aliased column names from the original query to the MV. SCO could have verified that was the case and omitted it for that reason.
Any work around for this?