Database Administration (MOSC)

MOSC Banner

I thought DBA_OBJECTS include all objects in CDB and all PDBs?

edited Jul 3, 2024 8:45PM in Database Administration (MOSC) 5 commentsAnswered ✓

I'm running this query from the CDB and I get nothing. But when I run from PDB I get result

I thought it should show up in the CDB!! but nope!

Am I missing something in my logic?

proof, using dummy data (Oracle 12c - I don't use it anymore - perhaps bugged?)

Running from PDB, I get no rows selected

Running same query from PDB gives me result

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