Is it possible to extract the datafile sizes of read only PDB from CDB client connection
I would like to extract the data file and temp file sizes from all PDBS in a CDB using a client connection.
The views I am using are CDB_DATA_FILES and CDB_TEMP_FILES.
The issue I have is that some of the PDBs are read/only and I get
"ORA-16000: database or pluggable database open for read-only access"
Which does not make sense because I am only reading data.
Is there some other way I can do this without having to log onto the database server and directly connect to the database?
This appears to affect both 12 and 19c Oracle databases.