ORA-01652: unable to extend temp segment by 64 in tablespace APPS_TS_INTERFACE ..... need help
Shop is getting errors below. Looks like error starts to occur when largest contiguous free space is at 512K. There are unused space on the datafiles(3) and all are set to autoextend.
Tablespace Name KBytes Used Free Used Largest
APPS_TS_INTERFACE 6,905,920 5,300,288 1,605,632 76.7 512
MODULE NAME:(GLAMAS)
----- Error Stack Dump -----
ORA-01652: unable to extend temp segment by 64 in tablespace APPS_TS_INTERFACE
----- Current SQL Statement for this session (sql_id=7a2vjqp4pmptj) -----
INSERT into gl_alloc_int_2_20725149 (
formula_id,
formula_line_number,
entered_amount,
accounted_amount)
VALUES ( :fid, :fl_number, :fl_amount, :fl_amount) ................... <snip>
MODULE NAME:(GLPPOS)