CREATE MATERIALIZED VIEW IN ORACLE

DROP MATERIALIZED VIEW apps.XX_TEST_V_MV;

CREATE MATERIALIZED VIEW apps.XX_TEST_V_MV
NOLOGGING
PARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
ENABLE QUERY REWRITE
AS
select * from xx_emp