ORA-1652: unable to extend temp segment by x in tablespace YYY
Today i faced ORA-1652 error on my production environment , this type of issue is common with TEMP tablespace but here it comes on non-TEMP tablespace
i am curious about this error , because my datafiles are in ASM with autoextensible ON.
there may be no chance for getting ORA-1652 error .
Later i find out the root cause of the problem , as my datafile belonging to the corresponding
tablespace reached the maximum limit of allowed size .
As my tablepace is created as SFT (small file tablespace) , there should be a limitation of 32 GB
for each datafile (assuming that block size was 8k)
So i added one more datafile in affected tablespace using following query
alter tablespace yyy add datafile '+DATA' size 5000M;
And the issue got resolved.
Today i faced ORA-1652 error on my production environment , this type of issue is common with TEMP tablespace but here it comes on non-TEMP tablespace
i am curious about this error , because my datafiles are in ASM with autoextensible ON.
there may be no chance for getting ORA-1652 error .
Later i find out the root cause of the problem , as my datafile belonging to the corresponding
tablespace reached the maximum limit of allowed size .
As my tablepace is created as SFT (small file tablespace) , there should be a limitation of 32 GB
for each datafile (assuming that block size was 8k)
So i added one more datafile in affected tablespace using following query
alter tablespace yyy add datafile '+DATA' size 5000M;
And the issue got resolved.
No comments:
Post a Comment