Database Administration (MOSC)

MOSC Banner

ORA-01654: unable to extend index when we have more than 300Gb of free space

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

 
Hello,

We are facing a strange problem on our database. When the application try to do an insert on some tables (TABLE1 for example), it's encounter ORA-01654 however more than 300Gb is available.

  • The tablespace concerned is DATA , it's defined like :

         CREATE SMALLFILE TABLESPACE "DATA" DATAFILE NOLOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

      The tablespace contain  28 datafiles  like : '+DATA/Mydb/datafile/data.295.798113921' SIZE 32000M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE 32000M 

  • Error message

    SQL>   insert into

*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at " TABLE1", line 233
ORA-06512: at "TABLE1", line 159
ORA-01654: unable to extend index  TABLE1_PK by 128 in tablespace

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