Dear Experts,

I have couple of invalid SYS and SYSTEM objects in my pdb, because of it I am unable to run some of the packages in pdb. I tried to recompile them in PDB but I am getting below error.

Please help me to compile a package in pdb

Version: 12.1.0.2.0

Linux 6.4 64-bit

SQL> set linesize 150

SQL> /

COMP_NAME   STATUS

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

Oracle Enterprise Search   VALID

Oracle XML Database   VALID

Oracle Text   VALID

Spatial   VALID

Oracle Multimedia   VALID

Oracle Database Catalog Views   VALID

Oracle Database Packages and Types   VALID

JServer JAVA Virtual Machine   VALID

Oracle Database Java Packages   VALID

Oracle XDK   VALID

Oracle Real Application Clusters   OPTION OFF

COMP_NAME   STATUS

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

OLAP Analytic Workspace   VALID

Oracle OLAP API   VALID

Oracle Application Server Integration B2B   VALID

Oracle Application Server Integration BAM   VALID

Oracle Application Server Certificate Authority    VALID

Oracle Internet Directory   VALID

Oracle Application Server Metadata Repository Vers VALID

ion-R

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

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

FUSION_SOCIAL_CEF XUSERLOGINSYEAR_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XRANKINGS_CONV_MEMBER_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XRANKINGS_CONV_CONTRIB_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XRANKINGS_FLAGS_OPENED_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XRANKINGS_FLAGS_CLOSED_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XRANKINGS_LIKED_CONTRIB_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XRANKINGS_FOLLOWERS_MV  MATERIALIZED VIEW  INVALID NONE 3

FUSION_SOCIAL_CEF XMESSAGES_COLL_MV  MATERIALIZED VIEW  INVALID NONE 3

SYS WWV_DBMS_SQL  PACKAGE  INVALID METADATA LINK 4

SYSTEM MIS_MATCHED_OBJ_PRIVS  VIEW  INVALID NONE 4

FUSION FND_EXECUTE  PACKAGE BODY  INVALID NONE 4

SQL> alter package WWV_DBMS_SQL compile;

Package altered.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

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

  2 PDB$SEED  READ ONLY  NO

  3 FEMS13070  READ WRITE NO

  4 FEMS2837  READ WRITE NO

SQL> alter session set container=fems2837;       

Session altered.

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

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

alter package WWV_DBMS_SQL compile

*

ERROR at line 1:

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

Thanks,

Mohan