vbaidak

Checking UNDO Tablespaces per PDB:

SELECT b.name, a.con_id, a.tablespace_name, a.status FROM cdb_tablespaces a,v$pdbs b WHERE  a.tablespace_name LIKE 'UNDO%' and a.con_id=b.con_id;

Disabling Local UNDO Tablespaces for PDB (must be sysdba)

show con_name