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
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.