IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02)

 

IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02)

IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS.

MATERIALIZED VIEW  WITH  REFRESH FAST :

Now that we know how materialized view logs track changes to base tables we can use them to perform fast materialized view refreshes, i.e. refreshes where only the individual materialized view rows affected by base table changes are updated. This is also called “incremental” refreshing.

DBA 11 : SERVER SIDE CONFIGURATION:

Connect to U1 server.

Add Primary Key on DEPT table:

Create Materialized view log on top of DEPT table.

Now check tables under U1 Schema.

Now  on Client Side create materialized view with fast option.

DBA 12 :CLIENT SIDE CONFIGURATION:

Implementing stream replication using MATERIALIZED VIEW LOG:

Try to select materialized view (MV FAST)

Data was replicated to MV.

Now we can check mv log table.

DBA:3: SERVER SIDE CONFIGURATION:

Try to Insert some Records on DEPT table:

Check records under mlog$_dept.

DBA 11 :CLIENT SIDE CONFIGURATION:

Try to Check Records updated or not:

 

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

Add Comment