CREATE MATERIALIZED VIEW

alter session set "_ORACLE_SCRIPT"=true;
CREATE USER BURAK IDENTIFIED BY s1;
GRANT RESOURCE, CONNECT TO BURAK;

ALTER USER BURAK QUOTA 100M ON users;

GRANT CREATE MATERIALIZED VIEW TO BURAK;

CREATE MATERIALIZED VIEW test_mv
AS SELECT * FROM BURAK.test_objects;

CREATE MATERIALIZED VIEW LOG ON BURAK.test_objects
INCLUDING NEW VALUES;

CREATE MATERIALIZED VIEW test_mv
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS SELECT * FROM BURAK.test_objects;