I've got six tables joining together using IN-DB tools to do so from an Oracle server. However I'm wanting to join these six to some additional data in another database (and I understand that I can't use the IN-DB JOIN to do this as they're separate databases?) - so I'm wanting to Output the data from both sources and join them together before use.
However, when trying to export the six table side I get ORA-01652 error which I believe relates to the size of the temp file. There's nothing I can really do about the size of the temp file and I can't think of any other solutions to join these tables together!
Even if I did join them together it feels like this error will just appear later down the workflow anyway!
My only other option is to revert to In/Out tools but then workflows regularly hit 40minute run times... which isn't acceptable.
It's a good option. But further down the workflow it's going to need to come back out to link with data from another database because the IN-DB tools don't accept cross DB Joins. That's where it's still going to fall over and not have enough temp space.