Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center