- 3,734,451 Users
- 2,246,973 Discussions
- 7,857,297 Comments
- 17.8K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 57 Insurance
- 533.3K On-Premises Infrastructure
- 137.3K Analytics Software
- 38.5K Application Development Software
- 5.1K Cloud Platform
- 109K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.7K Infrastructure Software
- 105K Integration
- 41.5K Security Software
How to import data files using SQL Loader on a FTP site daily
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.