Hi, DBAs
This is RAC/ASM 12.1.0.2 on Oracle Linux 6. I found a query in Mos note "Script For Getting Complete Basic Information about configured CDB and PDB in Oracle Database Multitenant 12c (Doc ID 2012221.1)", but it returns no records. I would like to list all the container's data files and those of its pluggables. The statement from the note is:
select 'Data Files for Each PDB in a CDB:' from dual;
SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME
FROM DBA_PDBS p, CDB_DATA_FILES d
WHERE p.PDB_ID = d.CON_ID
ORDER BY p.PDB_ID;
I am connected to CDB$ROOT. CDB_DATA_FILES.CON_ID=1, but all records returned from DBA_PDBS show DBA_PDBS.PDB_ID as greater than 1. There is no link.
Is there a different table or view that does link the two sets of data files somehow?
Thank you,
Laura Sallwasser