How to Resolve INVALID ILM-related VIEWs in a PDB (Doc ID 2491407.1)

Last updated on JULY 20, 2024

Applies to:

Goal

After plugging in a PDB, it shows an ILM-related view, such as SYS.DBA_ILMOBJECTS as INVALID.   However, the view is VALID in the CDB and may also be VALID in other PDBs.   Using the example of DBA_ILMOBJECTS, 

• The command 'alter view dba_ilmobjects compile' from the PDB fails with the error "ORA-65040: operation not allowed from within a pluggable database".
• The command 'show errors view dba_ilmobjects' from the PDB fails with error "ORA-01730: invalid number of column names specified' as output".
• The command 'desc dba_ilmobjects' from the PDB fails with error "ORA-24372: invalid object for describe".

You need to resolve the invalid ILM-related views.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.