temp + database oracle temp shrink How Oracle Resize Temp Tablespace - Ed Chen LogicAlter 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 | comment (2) | tweet
+ database oracle temp shrink How Oracle Resize Temp Tablespace - Ed Chen LogicAlter 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 | comment (2) | tweet