A quick referense for creating a snapshot (materialized view) in Oracle database:
create materialized view SCHEMA_NAME.SNAPSHOT_NAME
tablespace TABLESPACE_NAME
using index tablespace TABLESPACE_NAME
refresh FAST start with sysdate next sysdate + 1/48
-- with rowid
as
select * from SCHEMA_NAME.TABLE_NAME@DATABASE_LINK;
|