Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized view replication problem

Re: Materialized view replication problem

From: Bing Wu <bing_at_biop.ox.ac.uk>
Date: Fri, 15 Apr 2005 12:36:23 +0100
Message-ID: <d3o8vn$92$1@news.ox.ac.uk> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US