OraFAQ Forum: Replication » oracle 9i replication

Home » Server Options » Replication » oracle 9i replication

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: oracle 9i replication [message #75603 is a reply to message #75598]

Sat, 15 January 2005 09:12

Mohd Abdul Bari Jameel
Messages: 1
Registered: January 2005

Junior Member

what are the privileges requires to access remote
table?

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	Truncating Materialized Views
Next Topic:	Error Whle Refreshing Materialized View---Very Urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 06 05:19:22 CDT 2025