Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view refreshed through DBlink
Materialized view refreshed through DBlink [message #207063] Mon, 04 December 2006 01:12 Go to next message
Messages: 194
Registered: January 2006
Senior Member
I have a materialized view in database DB1 which I need to refresh in DB2.
create materialized view My_MV
tablespace my_ts
build deferred
refresh complete
with rowid 
select a.col1, b.col1, c.col1
  from TableA a, TableB b, TableC c;

I already granted a SELECT on the TableA, TableB and TableC to the DB2 user. When DB2 user runs:
dbms_mview.refresh ('DB1.MY_MV@DB1link');

I'm getting this error:
ORA-20000: ORA-00979: illegal reference to remote database
What am I missing here???
Re: Materialized view refreshed through DBlink [message #207139 is a reply to message #207063] Mon, 04 December 2006 04:56 Go to previous message
Messages: 20850
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-00979 means that there's an expression in SELECT which is not part of a group function arguments.

ORA-20000 should be user-defined exception.

What do those errors have to do with materialized view refresh? No idea.
Previous Topic: Is this Possible
Next Topic: CASE statement
Goto Forum:

Current Time: Sat Oct 22 17:01:29 CDT 2016

Total time taken to generate the page: 0.04718 seconds