database oracle temp shrink

How Oracle Resize Temp Tablespace - Ed Chen Logic

Alter Database Tempfile Resize Upsizing Upsizing a tempfile is easy, just make sure you set a larger size than the original but no more than the maximum size of a data file. For example: SQL> alter database tempfile '+DATA/ORCLCDB/ORCLPDB/temp01.dbf' resize 24g; Database altered. Downsizing As for downsizing a tempfile, it needs to be careful. Downsizing… Read More »How Oracle Resize Temp Tablespace

wono |

| wono

Shrinking A Temporary Tablespace In Oracle Database https://askmedawaa.wordpress.com/2020/11/22/shrinking-a-temporary-tablespace-in-oracle-database/

| wono

- 휴지통 보기 show recyclebin; - 휴지통 비우기 purge recyclebin; - 테이블 복구 flashback table table_name to before drop;