19c : Invalid DBMS_AQ at PDB level
Hi ,
SQL> connect / as sysdba
All SYS objects are VALID in CDB => OK
BUT : Many invalid objects in PDB
SQL> alter session set container=PDB;
@?/rdbms/admin/utldtchk.sql
D_OWNER D_NAME D_TYPE# D_OBJ# D_EDITION P_OWNER P_NAME P_TYPE# P_OBJ# REASON
--------- ---------------------- ------- ----------- ------------ -------- --------------- ------- ------------ ------------------
SYS DBMS_PRVTAQIS 9 15444 SYS DBMS_AQADM_SYS 9 15442 P Status: 5
SYS DBMS_AQADM_SYSCALLS 9 15447 SYS DBMS_AQADM_SYS 9 15442 P Status: 5
SYS DBMS_PRVTSQIS 9 15453 SYS DBMS_AQADM_SYS 9 15442 P Status: 5
SYS DBMS_AQADM_INV 11 18975 SYS DBMS_AQADM_SYS 9 15442 P Status: 5
SQL> alter package DBMS_AQADM_SYS compile ;