This content has been marked as final. Show 4 replies
Hi,1 person found this helpful
You need to put this file on the server you are using e.g Unix Server. Using FTP tools like filezilla or winscp you can move this file to $<TOP-Nane>/bin
Then execute the sqlldr command with appropriate arguments from Server.
Thank you very much for your help....
So even if I running from client system, I need to place the file in server...
Please let me know, if you know the path for R12.1.1....( to place the ctl file)
Thanks and Regards,
The good practice is, If you are using oracle apps then register a concurrent program of type sql*loader
put yor ctl file in $<ANY_TOP>/bin. Run Concurrent program to load the data.
I am just givng you the hints, You search on google u will get multiple ways to do the same things.
There are lots of ways like using of external table,UTL_FILE or Shell Script to do the same thing.
Thank you very much for your guidence...