-
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
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|