OraFAQ Forum: Replication

Home » Server Options » Replication » Replication

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

Replication [message #247055]

Sat, 23 June 2007 04:58

logina
Messages: 11
Registered: June 2007
Location: hyd

Junior Member

hi all,
I am using oracle 10g. i am trying to do MATERIALIZED VIEW replication.
for that i got 3 commands procedure:
i had 2 databases like 1.source (otest), 2.dest (otest1)

On the destination system

CREATE DATABASE LINK to_source_system
CONNECT TO username_on_source_system
IDENTIFIED BY password_on_source_system
USING 'tns_name_for_source_system_on_dest_system';

On the source system

CREATE MATERIALIZED VIEW LOG
ON table_to_replicate
WITH PRIMARY KEY
INCLUDING NEW VALUES;

On the destination system

CREATE MATERIALIZED VIEW table_to_replicate
REFRESH FAST
START WITH sysdate + 5/(24*60)
NEXT sysdate + 5/(24*60)
AS
SELECT * FROM table_to_replicate@to_source_system.

but the 3rd command not working.It is giving error as ORA-12154: TNS:could not resolve the connect identifier specified
. Any help please.

Report message to a moderator

Re: Replication [message #247061 is a reply to message #247055]

Sat, 23 June 2007 06:50

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Can you connect TO the source database with SQL*Plus FROM the destination database using the 'tns_name_for_source_system_on_dest_system' you specified in the database link?

Report message to a moderator

Re: Replication [message #247109 is a reply to message #247061]

Sun, 24 June 2007 02:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

CHECK your service .
Check your listener.
CHECK the ports for listeneing and in service names.

Report message to a moderator

Previous Topic:	Simple MV not being used.
Next Topic:	Materialized view complete refresh

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 03 03:30:15 CDT 2026