Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-1654: unable to extend index xx by 128/1024 in tablespace INDX

Ali Raza MemonJul 28 2022

The INDX tablespace has already enough space approx. 20 GBs.

tbs_name   tbs_max_mega_bytes   tbs_mega_bytes  tbs_free_mega_bytes tbs_percent_free  tbs_used_of_max
--------   ------------------   --------------  ------------------- ----------------  ----------------
INDX       223231.94            104168          19922               19.12             37.74

But still getting the following error in the alert log:
ORA-1654: unable to extend index xx by 128 in tablespace INDX
What could be the root cause?

This post has been answered by Jonathan Lewis on Aug 1 2022

Jump to Answer

Added on Jul 28 2022

#11gr2, #bi, #error, #general-database-discussions, #odi, #performance

3 comments

763 views