I have data file of 32G in which 18G occupied ( still has 14GB free space left) , the insert got failed with ORA-01658 : Unable to create INITIAL extent for segment in tablespace <TS_NAME>.
IS there any other solution than adding a data file? I already have 14GB space then why its causing space issue?
Is there any way I can adjust initial extent size to avoid this issue now and in future?
Thank You
I tried finding how to adjust initial extent size but some people mentioned we shouldn't alter that.