tablespace issues
I have a query that is obviously not written very well. I get the error:
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
01652. 00000 - "unable to extend temp segment by %s in tablespace %s"
*Cause: Failed to allocate an extent of the required number of blocks for
a temporary segment in the tablespace indicated.
*Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.
This usually means to me that my query is written poorly and cannot return the value within a decent time.
If you look at the last couple of lines of the code I can search by order number and it returns my 1 row of data in less than a second. Use the dates, expecting multiple rows and it errors out.
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
01652. 00000 - "unable to extend temp segment by %s in tablespace %s"
*Cause: Failed to allocate an extent of the required number of blocks for
a temporary segment in the tablespace indicated.
*Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.
This usually means to me that my query is written poorly and cannot return the value within a decent time.
If you look at the last couple of lines of the code I can search by order number and it returns my 1 row of data in less than a second. Use the dates, expecting multiple rows and it errors out.
0