<div>
The pass through query will be executed on the server side, so I'm afraid that your Access table will not be seen from there. Can't you use a normal query to populate the Oracle linked table thru ODBC?
</div>


The pass through query will be executed on the server side, so I'm afraid that your Access table will not be seen from there. Can't you use a normal query to populate the Oracle linked table thru ODBC?

<div>
yes I can but it is taking a long time to load the Oracle table. &nbsp;I am looking for a faster method of loading.<br />
<br />

</div>


yes I can but it is taking a long time to load the Oracle table.  I am looking for a faster method of loading.



<div>
I am not sure where the bottleneck is. Is is Access, or is it Oracle: Try to load your Access table into another Access database. <br />
<br />
If it is faster, then you will need to drop the indexes on the Oracle table before the upload, and recreate them when finished. This is what is usually done. Also, if the table is large, you could tune your oracle.ini file, increasing LARGE_POOL_SIZE and mostly SHARED_POOL_SIZE. (I personally doubled the default values)<br />
<br />
If it is not faster, Access is the bottleneck and all you can try is compacting the database, or optimizing the query. Can you paste the SQL here?<br />
<br />

</div>


I am not sure where the bottleneck is. Is is Access, or is it Oracle: Try to load your Access table into another Access database.

If it is faster, then you will need to drop the indexes on the Oracle table before the upload, and recreate them when finished. This is what is usually done. Also, if the table is large, you could tune your oracle.ini file, increasing LARGE_POOL_SIZE and mostly SHARED_POOL_SIZE. (I personally doubled the default values)

If it is not faster, Access is the bottleneck and all you can try is compacting the database, or optimizing the query. Can you paste the SQL here?



<div>
<div class="content wysiwyg-content">
What is the syntax for loading an Oracle from an access tbl using a pass through query? &nbsp;I'm not sure how to reference the access table in the sql statement.<br />
<br />

</div>
</div>


What is the syntax for loading an Oracle from an access tbl using a pass through query?  I'm not sure how to reference the access table in the sql statement.



Load Oracle tbl using pass through query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.