| updatable replication [message #75034] |
Thu, 29 March 2001 05:08  |
shekharbabu
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  |
yushuai
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...
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
