title: How to create materialized view log on the remote database
body: <p>Here our issue is we have to create materialized view logs on the remote database's base tables </p>
  
  <p>for respective materialized views on the local database</p>
  
  <p>Both local and remote databases are Oracle 11g (11.2)</p>
  
  <p>example:
   s1 and s2 are two schemas</p>
  
  <p>s1 schema is on the local databse
  s2 schema is on the remote databae</p>
  
  <p>we have to create materialized view logs on the s2 schema(Remote database)</p>
  
  <p>we created database link for accessing the s2 schema's objects(Remote database)</p>
  
  <p>But we are getting this error ORA-00949 'illegal reference to remote database'</p>
  
  <p>But in s1 schema(local database) we are able to creating  the materialized views</p>
  
  <p>Thanks</p>
  
  <p>Ragav</p>