Problem in Mat view execution through dblinks
HI Experts,
I am refreshing MAT_VIEW's via dblinks. But during refresh i am getting below error.
I tried both with Complete and Fast. Both are getting errors.
Seems i missed some privilages.
Please assist me here..
With Fast option
*===========*
SQL> exec dbms_mview.refresh('CDS_BANK_BRANCH_NLD',*'F'*);
BEGIN dbms_mview.refresh('CDS_BANK_BRANCH_NLD','F'); END;
*
ERROR at line 1:
ORA-12018: following error encountered during code generation for
"ACCOUNTINFO"."CDS_BANK_BRANCH_NLD"
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2431
ORA-06512: at line 1
With Complete Option
--------------------------------
SQL> exec dbms_mview.refresh('CDS_BANK_BRANCH_NLD',*'C'*);
BEGIN dbms_mview.refresh('CDS_BANK_BRANCH_NLD','C'); END;
*
ERROR at line 1:
ORA-12018: following error encountered during code generation for "ACCOUNTINFO"."CDS_BANK_BRANCH_NLD"
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2431
ORA-06512: at line 1