Friday, August 10, 2012

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.



No comments:

Post a Comment