Oracle - Create MVIEW

Create MVIEW

CREATE MATERIALIZED VIEW AP_TIPO_IND_2G
TABLESPACE AP_DATA_BIG
USING INDEX TABLESPACE AP_INDEX_BIG
REFRESH FAST NEXT SYSDATE + 1/4096
WITH PRIMARY KEY
AS SELECT * FROM AP.AP_TIPO_IND@CONSULTA_DBAP;

CREATE MATERIALIZED VIEW AP_VLR_IND_2G
TABLESPACE AP_DATA_BIG
USING INDEX TABLESPACE AP_INDEX_BIG
REFRESH FAST NEXT SYSDATE + 1/4096
WITH PRIMARY KEY
AS SELECT * FROM AP.AP_VLR_IND@CONSULTA_DBAP;

CREATE MATERIALIZED VIEW AP_PARAM_ATL_VLR_2G
TABLESPACE AP_DATA_BIG
USING INDEX TABLESPACE AP_INDEX_BIG
REFRESH FAST NEXT SYSDATE + 1/4096
WITH PRIMARY KEY