Temp tablespace details in Multitenant - Oracle Database Script. SELECT a.name, b.FILE_ID, b.tablespace_name, b.file_name FROM V$CONTAINERS a , CDB_TEMP_FILES b WHERE a.con_id=b.con_id;
SELECT a.name, b.FILE_ID, b.tablespace_name, b.file_name FROM V$CONTAINERS a , CDB_TEMP_FILES b WHERE a.con_id=b.con_id;