Oracle DBA

Oracle Data Pump & SQL*Loader

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.

This is 18 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples