how to resolve ORA-1652: unable to extend in tablespace XXXX_DAT...???
Hello
I am doing an INSERT to a partitioned table and I get the message: ORA-1652: unable to extend temp segment by 128 in PORTAL_DAT tablespace, the PORTAL_DAT tablespace is 32 GB and 2% is occupied, that is, it still has 30 Gb free .
I am doing the query:
select inst_id, tablespace_name, total_blocks, used_blocks, free_blocks from gv $ sort_segment
ORDER BY 1;
Result:
INST_ID TABLESPACE_NAME TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS
1 TEMP 6608512 512 6608000
2 TEMP 1776256 256 1776000