Database Administration (MOSC)

MOSC Banner

Materialized View Runtime Error: PLS-00907: cannot load library unit SYS.DBMS_STANDARD

edited Apr 12, 2019 3:56PM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center