New parameters in expdp Utility
ATTACH Attach the client session to existing data pump jobs
CONTENT Specify what to export(ALL, DATA_ONLY, METADATA_ONLY)
DIRECTORY Location to write the dump file and log file.
ESTIMATE Show how much disk space each table in the export job consumes.
ESTIMATE_ONLY It estimate the space, but does not perform export
EXCLUDE List of objects to be excluded
INCLUDE List of jobs to be included
JOB_NAME Name of the export job
KEEP_MASTER Specify Y not to drop the master table after export
NETWORK_LINK Specify dblink to export from remote database
NOLOGFILE Specify Y if you do not want to create log file
PARALLEL Specify the maximum number of threads for the export job
VERSION DB objects that are incompatible with the specified version will not be exported.
ENCRYPTION_PASSWORD The table column is encrypted, then it will be written as clear text in the dump file set when the password is not specified. We can define any string as a password for this parameter.
COMPRESSION Specifies whether to compress metadata before writing to the dump file set. Values are: ALL, (METADATA_ONLY), DATA_ONLY and NONE.
SAMPLE - Allows you to specify a percentage of data to be sampled and unloaded from the source database. The sample_percent indicates the probability that a block of rows will be selected as part of the sample.
REMAP_DATA = Used to Mask (hide) data
Equivalent imp & impdp parameters
These below parameters are equivalent parameters between imp & impdp
ATTACH Attach the client session to existing data pump jobs
CONTENT Specify what to export(ALL, DATA_ONLY, METADATA_ONLY)
DIRECTORY Location to write the dump file and log file.
ESTIMATE Show how much disk space each table in the export job consumes.
ESTIMATE_ONLY It estimate the space, but does not perform export
EXCLUDE List of objects to be excluded
INCLUDE List of jobs to be included
JOB_NAME Name of the export job
KEEP_MASTER Specify Y not to drop the master table after export
NETWORK_LINK Specify dblink to export from remote database
NOLOGFILE Specify Y if you do not want to create log file
PARALLEL Specify the maximum number of threads for the export job
VERSION DB objects that are incompatible with the specified version will not be exported.
ENCRYPTION_PASSWORD The table column is encrypted, then it will be written as clear text in the dump file set when the password is not specified. We can define any string as a password for this parameter.
COMPRESSION Specifies whether to compress metadata before writing to the dump file set. Values are: ALL, (METADATA_ONLY), DATA_ONLY and NONE.
SAMPLE - Allows you to specify a percentage of data to be sampled and unloaded from the source database. The sample_percent indicates the probability that a block of rows will be selected as part of the sample.
REMAP_DATA = Used to Mask (hide) data
Equivalent imp & impdp parameters
These below parameters are equivalent parameters between imp & impdp
| imp Command | impdp Command |
| DATAFILES | TRANSPORT_DATAFILES |
| DESTROY | REUSE_DATAFILES |
| FEEDBACK | STATUS |
| FILE | DUMPFILE |
| FROMUSER | SCHEMAS, REMAP_SCHEMAS |
| IGNORE | TABLE_EXISTS_ACTION(SKIP,APPEND,TRUNCATE,REPLACE) |
| INDEXFILE, SHOW | SQLFILE |
| LOG | LOGFILE |
| TOUSER | REMAP_SCHEMA |
No comments:
Post a Comment