Parellal insert statement against same global temporary table

Database
N/A

Parellal insert statement against same global temporary table

Hi Gurus,  I have three scripts running in parellal and each of them using INSERT statement to same global temp table. Can it cause any issue? Thanks for your help. 

2 REPLIES
N/A

Re: Parellal insert statement against same global temporary table

No, because every session uses it's own version of that table.

Do you finally Insert/Select into a permanent target table?

N/A

Re: Parellal insert statement against same global temporary table

Got it! Thank you. Yes, I am loading data to permenant target table at end of my script.