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.
