-
Book Overview & Buying
-
Table Of Contents
Oracle Database 12c Backup and Recovery Survival Guide
By :
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