Re: Materialized view replication problem

From: Bing Wu <bing_at_biop.ox.ac.uk>
Date: Thu, 14 Apr 2005 14:50:18 +0100
Message-ID: <d3lseq$5u3$1@news.ox.ac.uk>

Carlos wrote:
> Check the user/password authentication to the remote DB in the dblink
> definition.
>

Yes, I can do both these SQLs via REPADMIN or SCOT w/o problem.

SELECT * FROM SCOT.EMP_at_REMOTE_SITE;
SELECT * FROM SCOT.EMP; but not SYS user, in which I got error:

ERROR at line 1:
ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from REMOTE_SITE

Does this has anything to do with the problem?

I use REPADMIN in 'create database link' and the same user/pass exists on the remote site (Master).

tia,

Bing Received on Thu Apr 14 2005 - 08:50:18 CDT