Add Temp files in Oracle Database 12c,19c

To add a temp file to the TEMP tablespace in Oracle Database,

Query to find current tempfile details

col file_name for a72

col tablespace_name for a10

col AUTOEXTENSIBLE for a10

set lines 300

select file_name,autoextensible, bytes/1024/1024/1024 as total_gb from dba_temp_files;

If OMF is not enabled in your database, execute below to add tablespace:

alter tablespace temp add tempfile '<path>/<file_name>' size 10G;

If OMF is enabled in your database, execute below to add tempfile:

alter tablespace temp add tempfile size 10G;

Hey🙂 one minute, do you know if your Oracle Database is OMF enabled?

Checkout the below link to learn more ⬇️

https://www.analyzenow.co.in/post/is-omf-enabled-in-your-oracle-database-12c-and-19c