Sometimes you just need a list of the Data Pump parameters in one place.
You’re welcome.
Quick links to the versions:
Oracle Database 12c Data Pump Export
Oracle Database 12c Data Pump Import
Oracle Database 12c Data Pump Export:
PARAMETER | PARAMETER | PARAMETER |
---|---|---|
ACCESS_METHOD | EXCLUDE | PARFILE |
ATTACH | FILESIZE | QUERY |
CLUSTER | FLASHBACK_SCN | REMAP_DATA |
COMPRESSION | FLASHBACK_TIME | REUSE_DUMPFILES |
COMPRESSION_ALGORITHM | FULL | SAMPLE |
CONTENT | HELP | SCHEMAS |
DATA_OPTIONS | INCLUDE | STATUS |
DIRECTORY | JOB_NAME | TABLES |
DUMPFILE | KEEP_MASTER | TABLESPACES |
ENCRYPTION | LOGFILE | TRANSPORT_FULL_CHECK |
ENCRYPTION_ALGORITHM | LOGTIME | TRANSPORT_TABLESPACES |
ENCRYPTION_MODE | METRICS | TRANSPORTABLE |
ENCRYPTION_PASSWORD | NETWORK_LINK | VERSION |
ESTIMATE | NOLOGFILE | |
ESTIMATE_ONLY | PARALLEL | |
Oracle Database 12c Data Pump Import:
PARAMETER | PARAMETER | PARAMETER |
---|---|---|
ACCESS_METHOD | KEEP_MASTER | SCHEMAS |
ATTACH | LOGFILE | SKIP_UNUSABLE_INDEXES |
CLUSTER | LOGTIME | SQLFILE |
CONTENT | METRICS | STATUS |
DATA_OPTIONS | NETWORK_LINK | STREAMS_CONFIGURATION |
DIRECTORY | NOLOGFILE | TABLE_EXISTS_ACTION |
DUMPFILE | PARALLEL | TABLES |
ENCRYPTION_PASSWORD | PARFILE | TABLESPACES |
ESTIMATE | PARTITION_OPTIONS | TRANSFORM |
EXCLUDE | QUERY | TRANSPORT_DATAFILES |
FLASHBACK_SCN | REMAP_DATA | TRANSPORT_FULL_CHECK |
FLASHBACK_TIME | REMAP_DATAFILE | TRANSPORT_TABLESPACES |
FULL | REMAP_SCHEMA | TRANSPORTABLE |
HELP | REMAP_TABLE | VERSION |
INCLUDE | REMAP_TABLESPACE | VIEWS_AS_TABLES |
JOB_NAME | REUSE_DATAFILES | |