This content has been marked as final. Show 2 replies
SQL*Loader running on the database server cannot automatically read/access files on the client PC. One option you have is to create a share directory on the client PC, mount (or make available) that share on the database server (you seem to be using Unix) and modify your loader script to refer to the data file on that mounted share location. If the sharing/mounting cannot be done, then either you will have to manually copy the file over, or have your user somehow copy the file over to the server (maybe ftp ?).
I am using Data file for SQL LOADER, on server Path = /oradata/d01/oracle/PROD/apps/apps_st/appl/pay/12.0.0/bin (my_data_file.txt)
every time user created file i need to manualy placed on EBS server on above path ,
Iis it possible that user can chose file by EBS Concurrent programm (That placed on user or clint PC ) like c:\my_data_file.txt .
We have similar programs and we upload the files to the application server. Those directories are shared on a file server and can be accessed by specific end users who have read/write permission from their client machines.