Many invalid objects in PDB, how to solve it?
$ sqlplus sys/password@PDBNAME as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 1 11:36:41 2023
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL> SELECT count(*) FROM DBA_OBJECTS WHERE STATUS != 'VALID';
COUNT(*)
----------
3075
But in CDB
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 1 11:36:16 2023
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL> SELECT count(*) FROM DBA_OBJECTS WHERE STATUS != 'VALID';
COUNT(*)
----------
0