Materialized View Runtime Error: PLS-00907: cannot load library unit SYS.DBMS_STANDARD
Hello,
We have Materialized view running between 2 databases. both are in 12.2.0.1, Recently we are seeing errors, as below and MV is not happening.. I couldn't find this error in google or in Oracle support website.
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit SYS.DBMS_STANDARD@REMOTEDB (referenced by SYS.DBMS_SNAPSHOT_UTL@REMOTEDB)
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2952
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2370
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 85
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 245
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2352
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2908