Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center