ODI Temp Size Issue causing etl process to go in error

Hamza Shakeel

Hi guys,

I am facing a problem guys. A particular fact had multiple updates, upto 36 million records were updated. When the ETL process executed it went to error giving the error  Unable to extend temp segment by 128 in tablespace TEMP.

I have tried increasing the size of TEMP but it fails again and again.

My current TEMP size is 320 gb.

How can I solve this issue.

Note that this is Incremental Update I am running. Not full load.

Regards.

Joel

I think you need to move this to the   forum.