Data Pump files

Data Pump jobs manage few types of files; they are:

• Dump files; these files contain all the data and metadata that is being moved (generated as per the DUMPFILE parameter input).

• A log file that records all outputs related with an import or export operation (when using the LOGFILE parameter).

• SQL files that contain the results of a SQLFILE operation (when using the SQLFILE parameter). In other words, this file will enclose a dump of all SQL DDL statements that import operations would execute without really executing the real import.

• Datafile copies that will be used during a transportable import operation (specified in the DATA_FILE parameter).

Roles for Data Pump export and import

If you are required to perform export and import operations using Data Pump, you will need to have the following roles assigned to the user account that will be used with the expdp and impdp utilities:

• DATAPUMP_EXP_FULL_DATABASE

• DATAPUMP_IMP_FULL_DATABASE

The DATAPUMP_EXP_FULL_DATABASE role gives you...