Home » Server Options » Replication » updatable replication
updatable replication [message #75034] Thu, 29 March 2001 05:08 Go to next message
Messages: 1
Registered: March 2001
Junior Member
hello.. can any tell How to do the updatable replication with small example ? Thanks in advance.

Re: updatable replication [message #75035 is a reply to message #75034] Sat, 31 March 2001 02:26 Go to previous message
Messages: 5
Registered: December 2000
Junior Member
First,create a database link on the client
sql>create database link mylink
using connect_string;
Second,create a snapshot log on the server if you
want a fast refresh
sql>create snapshot log on table_original;
Third,create a updatable snapshot on the client
sql>create snapshot snapshot_name
for update
as select * from table_original@mylink;

It is ok.
But I met some trouble on the database link...

Previous Topic: ORA-03113: end-of-file on communication channel
Next Topic: Moving data using Materialsed Views - PLEASE HELP ASAP!!!
Goto Forum:

Current Time: Fri Oct 30 00:38:09 CDT 2020