How to Resolve INVALID ILM-related VIEWs in a PDB
(Doc ID 2491407.1)
Last updated on OCTOBER 23, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document