Both methods will generate a dump file with extension file_name .dmp
The Export dump file is an Oracle binary-format dump file. The dump file name and path directory is pre-determined before running the export utility.
Start Exporting Data:
Expdb Scott/tiger@orcl file=test.dmp log= test_log.log full=y;
The Data Pump Export utility is invoked using the expdp command. The characteristics of the export operation are determined by the export parameters you specify. These parameters can be specified either on the command line or in a parameter file.
Expdp Vs. Exp
- Both does the same functionality; Exporting data.
- The original Export utility dates back to the earliest releases of Oracle, and it's quite slow and primitive compared to Data Pump that gives 15 – 50% performance improvement than exp/imp.
The SQL statements contained in the export are displayed in the order in which Import will execute them.