Skip to content

Instantly share code, notes, and snippets.

@mpfund

mpfund/oracle_exception_01652.txt

Created July 14, 2014 08:10
Show Gist options
  • Save mpfund/c70faec011198fae7324 to your computer and use it in GitHub Desktop.
Save mpfund/c70faec011198fae7324 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Exception 01652 "unable to extend temp segement" & fix
Raw
oracle_exception_01652.txt
Oracle Exception:
{"ORA-01652: unable to extend temp segment by 2048 in tablespace TS_TEMP"}
Fix:
SELECT file_name, tablespace_name, ROUND(bytes/1024000) MB
FROM dba_data_files
ORDER BY 1;
alter tablespace ts_temp add TEMPFILE 'C:\app\inloox_oracle\product\12.1.0\dbhome_2\database\TEMP04.dbf' size 2000M autoextend on;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment