Search code examples
oracleplsqlexternal-tables

Oracle : load data from client machine

I'm looking for a solution to read the data from client machine and load into oracle database , by using sql loader/external table first we need to copy the file into oracle server directory to load but looking for any alternative by using any recent oracle functionality that allows to read from client machine into oracle DB

Thanks in Advance

expecting load data from client machine to oracle database

Solution

  • Nope! SQLLDR does not require you to copy the file on the database server. It only requires that you have Oracle client installed on your client machine. So, install Oracle client, which includes SQLLDR and load the data using SQLLDR.