Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to import data files using SQL Loader on a FTP site daily

Christian PitetJun 11 2021

Hi,
I need to import daily a file with data into a table using SQL Loader. This file would be put everyday automatically on the FTP site and I need to import the data daily into a table.
If there are duplicates records, there should be skipped in order for the importation to run without errors.
The Database is version 12.1, the DB server is running under Windows 2012 R2 Standard.
Is there any documentation or how-to on how to achieve this ? I am a novice with SQL Loader.
Best regards,
Christian

This post has been answered by EdStevens on Jun 15 2021
Jump to Answer
Comments
Post Details
Added on Jun 11 2021
5 comments
1,238 views