Oracle: How to filter results based on a large number of IDs[20K]
<p>I get a file as input, and I have to load data[In memory] corresponding to all the IDs present in the file. </p>

<p>I have tried following.</p>

<ul>
<li><p>Insert IDs into a temporary table and then do a join, but that is
creating issues for parallel runs. Means multiple instances of same
application cannot share same temp table. Here I cannot create one
temp table per execution.</p></li>
<li><p>'in` clause where I can pass list of IDs, but there is a limit on
size of query.</p></li>
</ul>

<p>How should I approach this problem?</p>