Question
Data Pump versus SQL*Loader: what does each move, and when should each be used?
Answer
Data Pump moves database metadata and data between Oracle databases. SQL*Loader loads external flat-file data into tables. Use Data Pump for logical migration or refresh; use SQL*Loader for file ingestion.