advanced code snippet search

Posted By

geekzspot on 01/24/13


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

pedro84


Increase Oracle TEMP space

 / Published in: SQL
 

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Expand | Embed | Plain Text 
  1. -- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
  2.  
  3. SELECT tablespace_name, bytes_used, bytes_free FROM v$temp_space_header;
  4.  
  5. SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP';
  6.  
  7. ALTER DATABASE TEMPFILE '/oradata/DBNAME/temp_01.dbf' resize 2G;

Report this snippet  

You need to login to post a comment.