Which Oracle version ?
Check for any hung or active transactions which might have occupied space from v$sort_segment, v$sort_usage.
Try to coalesce. If no usage and still no free space, try to take it offline and then online again else add more space.




Reply With Quote