Oracle replication !!!

From: <stas_at_terraspace.ru>
Date: Thu, 04 Mar 1999 08:54:37 GMT
Message-ID: <7blhoa$t6r$1@nnrp1.dejanews.com>

Guys!

After long discussion, I collect a lot of different advices. But the problem is still ... actual.

I made

CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger; or
CREATE DATABASE LINK den.world.com CONNECT TO scott IDENTIFIED BY tiger; etc ...

Also entering Schema Manager (in Enterprise Manager) choosing Database link DEN, I see that it hasn't "Service name". Is it correct?
Pressing Test button I get message "The Database Link is not active" ???

All what I did described in "Oracle Server Replication" documentation. I got several mail from other users with the same problem. I'm not alone.

The problem still the same:

CREATE SNAPSHOT scott.par AS SELECT * FROM scott.par_at_den

                                                   *

ORA-02019: connection description for remote database not found

But connect scott/tiger_at_den works.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 02:54:37 CST