Hi All,
Last week we have encountered a weird kind of situation on our oracle production machine. We have got an error as below -
ORA-01654: unable to extend index SAPSCH.DATCAL~0 by 1024 in tablespace TSAPPT2"
When we checked there was around 18GB of free space in this tablespace.
Tablespace info
---------------------
- Pos. Tablespace Type Status ExtMan. SegMan. Back. BigFi. Files/AuEx. Compr. Encr.
Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]
1 - TSAPPT2 DATA ONLINE LOCAL AUTO NO NO 10/10 OLTP NO
309964800 94.05 18430720 309964800 0 19905 960:960:960:960:960
Even there was sufficient space on file system level as well. Further we had to add datafile to this tablespace which has fixed the issue.
There is no quota assigned to this user on tablespace and also auto extend was OFF.
But we are not able to understand , if we had 18GB of space already free in tablespace why did we got "Not able to extend index" error.
Please suggest? thanks