top of page
Search

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 ⬇️

82 views0 comments

Recent Posts

See All

Commentaires


Contact Me

Tel: 7989359581

Lakshminarayana0071@gmail.com

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon

Thanks for submitting!

© 2023 by Phil Steer . Proudly created with Wix.com

bottom of page