i have to load a 3 Million rows from one Oracle table to another with
transformation on it.
During this process the temporay TBS growt indefinitly and CPU is 100%. This Load take many days but no row is loaded.
I make a commit every 100 rows.