Thanks in advance

Tablespace is having almost 2.9G free space.

select initial_extent,next_extent from dba_tablespaces where tablespace_name='PRONTOMSP';

INITIAL_EXTENT NEXT_EXTENT
-------------- -----------
10485760 10485760

i dont know why it is giving error. Any clues in this. ?

ORA-01652: unable to extend temp segment by 61446 in tablespace PRONTOMSP