ORA-1652: unable to extend temp segment by 38400 in tablespace

[gnagesh]

Originally posted by pando
better run this

select segment_name,segment_type, tablespace_name, next_extent, bytes
from dba_segments where next_extent >= (38400 * 8192)

Thanks pando. Here is the result.

SEGMENT_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE TABLESPACE_NAME NEXT_EXTENT BYTES
------------------ ------------------------------ ----------- ----------
SYS_IL0000011225C00004$$
LOBINDEX CASHIN_MST 314572800 314572800

SYS_IL0000010344C00005$$
LOBINDEX CASHIN_MST 314572800 314572800

SYS_LOB0000011225C00004$$
LOBSEGMENT CASHIN_MST 314572800 314572800

SYS_LOB0000010344C00005$$
LOBSEGMENT CASHIN_MST 314572800 314572800

Thanks In advance