Iam getting ORA-01652 unable to extend the temp segment

[Machlink]

I'm getting ORA-01652 unable to extend the temp segmentby 16 in tablespace temp01

Thanks in advance

 

[Turkbear]

Hi,
Ask your DBA to add extents ( or data files if at maxextents ) to the tablespace..While doing that, have your Query reviewed for efficiency ( the DBA can do that as well)

 

[Machlink]

I did added extents still Iam getting same error.

Thanks

 

[kskid]

Revisit your record selection. You ran out of space trying to bring over a huge amount of data.

You might also want to get with the DBA to kill the process which may still be running from your last attempt.