1 of 1 people found this helpful
Looks like the temp table in Oracle DB is getting full with the amount of data you're trying to load. Something you can try,
1) Request your DBA to increase the tempdb size.
2) Also avoid custom sql if you can and create the table in the database and let database do the heavy lifting, given that you tune your query and load data in increments.
Thank you Shivaram, I will check with my team to see If this is possible.
Welcome! Glad to help.