Here is the list of impdp available parameters for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page.
- impdp All Parameters for Oracle Database 21c
- impdp All Parameters for Oracle Database 19c (Also known as 12.2.0.3)
- impdp All Parameters for Oracle Database 18c (Also known as 12.2.0.2)
- impdp All Parameters for Oracle Database 12c Release 2 (12.2.0.1)
- impdp All Parameters for Oracle Database 12c Release 1 (12.1.0.2)
- impdp All Parameters for Oracle Database 11g Release 2 (11.2)
- impdp All Parameters for Oracle Database 11g Release 1 (11.1)
- impdp All Parameters for Oracle Database 10g Release 2 (10.2)
- impdp All Parameters for Oracle Database 10g Release 1 (10.1)
Further reading: expdp Parameter for All Releases of Oracle Database.
Next, I made a matrix which can show you all available parameters of impdp 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 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| CLUSTER | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| CONTENT | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| CREDENTIAL | ✓ | ✓ | |||||
| DATA_OPTIONS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| DIRECTORY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| DUMPFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| ENABLE_SECURE_ROLES | ✓ | ✓ | |||||
| ENCRYPTION_PASSWORD | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| ENCRYPTION_PWD_PROMPT | ✓ | ✓ | ✓ | ✓ | |||
| ESTIMATE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| EXCLUDE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FLASHBACK_SCN | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FLASHBACK_TIME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| FULL | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| HELP | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| INCLUDE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| JOB_NAME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| KEEP_MASTER | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| LOGFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| LOGTIME | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| MASTER_ONLY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| METRICS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| NETWORK_LINK | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| NOLOGFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| PARALLEL | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| PARFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| PARTITION_OPTIONS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| QUERY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| REMAP_DATA | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| REMAP_DATAFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| REMAP_DIRECTORY | ✓ | ✓ | ✓ | ✓ | |||
| REMAP_SCHEMA | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| REMAP_TABLE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| REMAP_TABLESPACE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| REUSE_DATAFILES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SCHEMAS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SERVICE_NAME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| SKIP_UNUSABLE_INDEXES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SOURCE_EDITION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| SQLFILE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| STATUS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| STREAMS_CONFIGURATION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TABLE_EXISTS_ACTION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TABLES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| TABLESPACES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TARGET_EDITION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| TRANSFORM | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORT_DATAFILES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORT_FULL_CHECK | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORT_TABLESPACES | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| TRANSPORTABLE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
| VERSION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| VERIFY_CHECKSUM | ✓ | ||||||
| VERIFY_ONLY | ✓ | ||||||
| VIEWS_AS_TABLES | ✓ | ✓ | ✓ | ✓ | ✓ |