Home » Server Options » Replication » oracle 9i replication
oracle 9i replication [message #75598] Sun, 02 January 2005 22:09 Go to next message
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 #75603 is a reply to message #75598] Sat, 15 January 2005 09:12 Go to previous messageGo to next message
Mohd Abdul Bari Jameel
Messages: 1
Registered: January 2005
Junior Member
what are the privileges requires to access remote
table?
Re: oracle 9i replication [message #75611 is a reply to message #75603] Tue, 01 February 2005 21:11 Go to previous message
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.
Previous Topic: Truncating Materialized Views
Next Topic: Error Whle Refreshing Materialized View---Very Urgent
Goto Forum:
  


Current Time: Thu Mar 28 17:50:22 CDT 2024