-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle Database 12c Backup and Recovery Survival Guide

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).
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...
Change the font size
Change margin width
Change background colour