METADATA LINK objects
From: DOUG KUSHNER <dougk5_at_cox.net>
Date: Mon, 5 Dec 2022 13:13:25 -0700 (MST)
Message-ID: <2140399484.1458507.1670271205731_at_myemail.cox.net>
In one of our production single-tenant RAC 19.16 databases, MV refreshes started failing. After a bit of troubleshooting, we discovered that a METADATA LINK object was invalid in the PDB where the MVs are running.
Date: Mon, 5 Dec 2022 13:13:25 -0700 (MST)
Message-ID: <2140399484.1458507.1670271205731_at_myemail.cox.net>
In one of our production single-tenant RAC 19.16 databases, MV refreshes started failing. After a bit of troubleshooting, we discovered that a METADATA LINK object was invalid in the PDB where the MVs are running.
The object is SYS.DBMS_SNAP_INTERNAL package body which is owned by the CDB. Querying the object from ALL_OBJECTS in the PDB returns no rows (as I assume is normal), but there are rows for both con_id 1 & 3 when queried from CDB_OBJECTS in the CDB. This is where we determined that it was invalid in the PDB (con_id=3).
I was able to recompile by running the following command from the PDB:
exec dbms_pdb.exec_as_oracle_script ('alter package SYS.DBMS_SNAP_INTERNAL compile body');
What could possibly make a 'METADATA LINK' object go invalid in a PDB?
Regards,
Doug
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 05 2022 - 21:13:25 CET