eseabrook2008
Technical User
This error has started coming up in the last couple days when we run queries that we've run many times in the past. I've googled the error and read many articles about what it means and how to resolve it but I'd like to understand why it's coming up in our particular situation. A quick look at the TEMPDATA01 tablespace in Oracle Storage Manager shows the file size is 63GB with 2GB used. Auto Extend is enabled with an increment of 1GB and a max extent of 63GB. I ran this query:
and it returned:
FILE_NAME BYTES AUT MAXBYTES
-------------------------- ---------- --- ----------
D:\...\TEMPDATA01.IBS 6.6060E+10 YES 6.8719E+10
Shouldn't there be enough room to extend?
The acutal error changes depending on the query but this particular error is:
Select error: ORA-01652: unable to extend temp segment by 655360 in tablespace TEMPDATA1.
Code:
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='TEMPDATA1'
and it returned:
FILE_NAME BYTES AUT MAXBYTES
-------------------------- ---------- --- ----------
D:\...\TEMPDATA01.IBS 6.6060E+10 YES 6.8719E+10
Shouldn't there be enough room to extend?
The acutal error changes depending on the query but this particular error is:
Select error: ORA-01652: unable to extend temp segment by 655360 in tablespace TEMPDATA1.