I thought DBA_OBJECTS include all objects in CDB and all PDBs?
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