Here is the list of expdp available parameters for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page.
- expdp All Parameters for Oracle Database 21c
- expdp All Parameters for Oracle Database 19c (Also known as 12.2.0.3)
- expdp All Parameters for Oracle Database 18c (Also known as 12.2.0.2)
- expdp All Parameters for Oracle Database 12c Release 2 (12.2.0.1)
- expdp All Parameters for Oracle Database 12c Release 1 (12.1.0.2)
- expdp All Parameters for Oracle Database 11g Release 2 (11.2)
- expdp All Parameters for Oracle Database 11g Release 1 (11.1)
- expdp All Parameters for Oracle Database 10g Release 2 (10.2)
- expdp All Parameters for Oracle Database 10g Release 1 (10.1)
Further reading: impdp Parameter for All Releases of Oracle Database.
Next, I made a matrix which can show you all available parameters of expdp between versions. Through the matrix, you can quickly learn which parameter is available in your database.
| Parameter | 10.2 | 11.2 | 12.1 | 12.2 | 18c | 19c | 21c |
|---|---|---|---|---|---|---|---|
| ABORT_STEP | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| ACCESS_METHOD | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| ATTACH | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| CHECKSUM | ✓ | ||||||
| CHECKSUM_ALGORITM | ✓ | ||||||
| CLUSTER | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| COMPRESSION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| COMPRESSION_ALGORITHM | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| CONTENT | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| CREDENTIAL | ✓ | ||||||
| DATA_OPTIONS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| DIRECTORY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| DUMPFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| ENABLE_SECURE_ROLES | ✓ | ✓ | |||||
| ENCRYPTION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| ENCRYPTION_ALGORITHM | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| ENCRYPTION_MODE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| ENCRYPTION_PASSWORD | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| ENCRYPTION_PWD_PROMPT | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| ESTIMATE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| ESTIMATE_ONLY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| EXCLUDE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FILESIZE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FLASHBACK_SCN | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FLASHBACK_TIME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FULL | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| HELP | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| INCLUDE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| JOB_NAME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| KEEP_MASTER | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| LOGFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| LOGTIME | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| METRICS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| NETWORK_LINK | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| NOLOGFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| PARALLEL | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| PARFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| QUERY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| REMAP_DATA | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| REUSE_DUMPFILES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| SAMPLE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SCHEMAS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SERVICE_NAME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| SOURCE_EDITION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| STATUS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TABLES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TABLESPACES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORT_DATAFILES_LOG | ✓ | ||||||
| TRANSPORT_FULL_CHECK | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORT_TABLESPACES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORTABLE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| TTS_CLOSURE_CHECK | ✓ | ✓ | |||||
| VERSION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| VIEWS_AS_TABLES | ✓ | ✓ | ✓ | ✓ | ✓ |