Database Software

Hi,

I would like recompile invalid package owned by SYS in PDB. This package point as METADATA LINK to package in SYS schema in CDB (it was recompiled sucessfully in CDB previously).

See scenario:

sqlplus sys/pass@192.168.0.1/cdb_db as sysdba

SQL> select con_id, owner, object_name, status from cdb_objects where object_name='HTMLDB_SYSTEM' and object_type='PACKAGE BODY';

------ ---------- ---------------  --------

SQL> alter session set container=pdb12;

Session altered.

SQL> show con_id

CON_ID

------------------------------

3

SQL> select owner,object_name, object_type,status,sharing,con_id from cdb_objects where status <>'VALID';

OWNER     OBJECT_NAME                OBJECT_TYPE     STATUS  SHARING           CON_ID

--------- -------------------------- --------------- ------- ------------- ----------

SYS       HTMLDB_SYSTEM              PACKAGE BODY    INVALID METADATA LINK          3

PUBLIC    APEX_PKG_APP_INSTALL_LOG   SYNONYM         INVALID METADATA LINK          3

SYS       HTMLDB_SYSTEM              PACKAGE BODY    INVALID METADATA LINK          2

PUBLIC    APEX_PKG_APP_INSTALL_LOG   SYNONYM         INVALID METADATA LINK          2

SQL> alter package SYS.HTMLDB_SYSTEM compile body;

alter package SYS.HTMLDB_SYSTEM compile body

*

ERROR at line 1:

ORA-65040: operation not allowed from within a pluggable database

How to compile HTMLDB_SYSTEM in PDB when refering to CDB over metadata link ?