This is not at all related with REPLICATION.
In my master database I have a table called Port and have created a snapshot log with primary key.
From another database I have created a snapshot using dblink.
Create snapshot port
refresh fast as
select * .................................
*** But after commiting a transaction(insert or update) in my master port table my snapshot is not getting refreshed automatically.
When I executed DBMS_SNAPSHOT.REFRESH it's doing that.
I wish to refresh my snapshot automatically after each commited transaction.
Is it possible.
Please give me information in details.
Create a trigger in the master table that execute the package dbms_refresh.
Check out the ON COMMIT option of the refresh clause when creating the materialized view (snapshot). There are some restrictions:
Click Here to Expand Forum to Full Width