Database Administration (MOSC)

MOSC Banner

ORA-01653: unable to extend table

edited Oct 25, 2010 6:22PM in Database Administration (MOSC) 4 commentsAnswered
(originally posted by djayA  but as a Document)

One job is running and user is gettin error below.
ERROR at line 1:
ORA-01653: unable to extend table IBSS.ECC_INS_OUTS by 3200 in tablespace IBSMED
ORA-06512: at "IBSS.ECC_INS_OUTS_P", line 19
ORA-06512: at "IBSS.ECC_INS_OUTS_P", line 231
ORA-06512: at line 1

Tablespace having around 58Gb free space.

Table statistics are DBA_SEGMENTS

OWNER      SEGMENT_NAME            EXTENTS INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS PCT_INCREASE
---------- -------------------- ---------- -------------- ----------- ----------- ------------
IBSS       ECC_INS_OUTS                134       52428800    26214400  2147483645            0

dba_tablespaces

SQL> select TABLESPACE_NAME,NEXT_EXTENT,MAX_EXTENTS,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces where TABLESPACE_NAME='IBSMED';

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