Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Materialized view replication problem
I think I found the problem. It was indeeed caused by database link -
more specificly, the owner of the database link. If make SCOTT as the
owner then all problems are solved.
Many thanks for all your great advice.
Bing
> Frank van Bortel wrote:
>
>> how did you define the database link? code snippet, please
>>
connect SCOTT
create database link REMOTE_SITE.FQD
connect to repadmin identified by PASSWD; CREATE MATERIALIZED VIEW ... Received on Fri Apr 15 2005 - 06:36:23 CDT