Reputation: 87
Here our issue is we have to create 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
Thanks
Ragav
Upvotes: 1
Views: 6407
Reputation: 718
There's supposed to be no problem with creating Mviews which perform Fast Refresh (refreshing an mview using mview log on target table) querying tables which are located on a remote site.
What you need to do:
select name, date from target_schema.target_table@remote_oracle_db;
)dbms_snapshot.refresh('local_schema.mview_x','c');
dbms_snapshot.refresh('local_schema.mview_x','f');
Upvotes: 3