| oracle 9i replication [message #75598] |
Sun, 02 January 2005 22:09  |
archa
Messages: 4
Registered: January 2005
|
Junior Member |
|
|
|
I am able to replicate data on a single system i.e, when master and slave are on the same system but now i want to move the slave db to a remote system.Someone plz guide me regarding this(I am using oracle 9i Advanced materialized view replication) .Do i have to create a stream for this purpose.I don't know how to make a link between two remote databases.I have created all master sites ,Materialized view sites,groups ,logs etc.
|
|
|
|
|
|
| Re: oracle 9i replication [message #75611 is a reply to message #75603] |
Tue, 01 February 2005 21:11  |
Sreedhar Reddy
Messages: 55
Registered: January 2002
|
Member |
|
|
Create tsnaname , database links.
Database link :
create public database link lnkremote connect to '<user>' identified by '<password>' using '<tsnname>'
once the database links are generated.
create materialized view mview as select * from emp@lnkremote
you can create your own materialized views for remote tables.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
