Database Administration (MOSC)

MOSC Banner

ORA-01652: unable to extend temp segment by 64 in tablespace APPS_TS_INTERFACE ..... need help

edited Apr 30, 2014 12:00PM in Database Administration (MOSC) 4 commentsAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center