Hello Experts,
I came through situation where I am not able to understand the reason behind the "unable to extend tablespace by 1024 error".
I have table X with in tablespace XY, I can see there is tablespace is 20%(20GB) free which seems enough to load my 2,00,0000 rows(I can say this because I tried inserting it and tablespace usage increased by 2 GB only).
Now when,I tried to insert in one go as below:
Insert into X
as select * from table Y.
It gives "unable to extend tablespace by 1024",
But when I restrict insertion with 1000 rows then I am able insert all 2,00,0000 in to table.
Not able to understand,why it gives error for tablespace ad in both the cases,same amount of tablespace will be used.
PS.I checked my tablespace is Locally Managed Tablespaces (LMT) and SEGMENT_SPACE_MANAGEMENT is AUTO,if this is making any difference.
Thank you