Hi all,
Recently, I have received the following error ->
ORA-1652: unable to extend temp segment by 128 in tablespace xxx
ORA-1652: unable to extend temp segment by 8192 in tablespace xxx
q1) By 128 and 8129, I would assume it is the number of blocks , and not the number of bytes that need to is requested for extension - right ?
q2) I understand that in a locally managed tablespace, continuous space are coalesce automatically. But if I have discontinued free space, what can be done ?
a) expdp impdp ? -- downtime required
b) alter table move newtablespace /rebuild tablespace etc ? -- downtime required
c) online redefinition ? -- never really use in production environment before
d) add datafile -- waste space.
p.s. my extend allocation are autoallocate
q3) I am not able to access the live database now and see if the my dba_free_space largest freespace is smaller then the next extent allocation required. But having discontinued free space could be a reason for the error above right ?
Regards,
Noob