https://dbaclass.com/article/how-to-find-the-temp-tablespace-usage/ select a.tablespace_name tablespace, d.TEMP_TOTAL_MB, sum (a.used_blocks * d.block_size) / 1024 / 1024 TEMP_USED_MB, d.TEMP_TOTAL_MB…

SQL> alter session set container=pdb1; Session altered. SQL> drop user hari; drop user hari *…

set newname for tablespace APPS_TS_SUMMARY to ‘/d01/DEV/oradata/DEV/%b’;