Hi Friends!!
I am facing an issue while I am creating materialized view logs on the remote database's base tables for respective materialized views on the local database.
Both local and remote databases are Oracle 11g (11.2)
example: s1 and s2 are two schemas
s1 schema is on the local databse s2 schema is on the remote databae
we have to create materialized view logs on the s2 schema(Remote database)
we created database link for accessing the s2 schema's objects(Remote database)
But we are getting this error ORA-00949 'illegal reference to remote database'
But in s1 schema(local database) we are able to creating the materialized views
Please suggest me in creating mv logs
Thanks in Advance
A