i want to load the data from CSV file to oracle table with this below condition.
if the table is empty then only the data should be loaded into table otherwise data should not be loaded.
is this requirement possible with sql loader ? or do i need to use any other ETL tool like informatica ?
Advertisement
Answer
You can use the loading option: INSERT for achieving it.
It requires the table to be empty before loading. SQL*Loader
terminates with an error if the table contains rows.
You can refer: Loading Data into Empty Tables
Cheers!!