Snapshot Refresh = Urgent

Hi,

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.

Thanks

Sumit

Create a trigger in the master table that execute the package dbms_refresh.

Regards

Angel

Check out the ON COMMIT option of the refresh clause when creating the materialized view (snapshot). There are some restrictions:

http://otn.oracle.com/docs/products/...4c.htm#2063839