Oracle : Impdp : Parameters
Paramètre | Description |
---|---|
ATTACH | Attach to existing job, e.g. ATTACH [=job name]. |
CONTENT | Specifies data to load where the valid keywords are:(ALL), DATA_ONLY, and METADATA_ONLY. |
DIRECTORY | Directory object to be used for dump, log, and sql files. |
DUMPFILE | List of dumpfiles to import from (expdat.dmp), e.g. DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp. |
ESTIMATE | Calculate job estimates where the valid keywords are:(BLOCKS) and STATISTICS. |
EXCLUDE | Exclude specific object types, e.g. EXCLUDE=TABLE:EMP. |
FLASHBACK_SCN | SCN used to set session snapshot back to. |
FLASHBACK_TIME | Time used to get the SCN closest to the specified time. |
FULL | Import everything from source (Y). |
HELP | Display help messages (N). |
INCLUDE | Include specific object types, e.g. INCLUDE=TABLE_DATA. |
JOB_NAME | Name of import job to create. |
LOGFILE | Log file name (import.log). |
NETWORK_LINK | Name of remote database link to the source system. |
NOLOGFILE | Do not write logfile. |
PARALLEL | Change the number of active workers for current job. |
PARFILE | Specify parameter file. |
QUERY | Predicate clause used to import a subset of a table. |
REMAP_DATAFILE | Redefine datafile references in all DDL statements. |
REMAP_SCHEMA | Objects from one schema are loaded into another schema. |
REMAP_TABLESPACE | Tablespace object are remapped to another tablespace. |
REUSE_DATAFILES | Tablespace will be initialized if it already exists (N). |
SCHEMAS | List of schemas to import. |
SKIP_UNUSABLE_INDEXES | Skip indexes that were set to the Index Unusable state. |
SQLFILE | Write all the SQL DDL to a specified file. |
STATUS | Frequency (secs) job status is to be monitored where the default (0) will show new status when available. |
STREAMS_CONFIGURATION | Enable the loading of Streams metadata |
TABLE_EXISTS_ACTION | Action to take if imported object already exists. Valid keywords: (SKIP), APPEND, REPLACE and TRUNCATE. |
TABLES | Identifies a list of tables to import. |
TABLESPACES | Identifies a list of tablespaces to import. |
TRANSFORM | Metadata transform to apply (Y/N) to specific objects. Valid transform keywords: SEGMENT_ATTRIBUTES and STORAGE. ex. TRANSFORM=SEGMENT_ATTRIBUTES:N:TABLE. |
TRANSPORT_DATAFILES | List of datafiles to be imported by transportable mode. |
TRANSPORT_FULL_CHECK | Verify storage segments of all tables (N). |
TRANSPORT_TABLESPACES | List of tablespaces from which metadata will be loaded. Only valid in NETWORK_LINK mode import operations. |
VERSION | Version of objects to export where valid keywords are: (COMPATIBLE), LATEST, or any valid database version. Only valid for NETWORK_LINK and SQLFILE. |
+ avec Oracle 10g Release 2 (10.2)
Paramètre | Description |
---|---|
ENCRYPTION_PASSWORD | Password key for accessing encrypted column data. This parameter is not valid for network import jobs. |
+ avec Oracle 11g Release 1 (11.1)
Paramètre | Description |
---|---|
DATA_OPTIONS | Data layer flags where the only valid value is: SKIP_CONSTRAINT_ERRORS-constraint errors are not fatal. |
PARTITION_OPTIONS | Specify how partitions should be transformed where the valid keywords are: DEPARTITION, MERGE and (NONE) |
REMAP_DATA | Specify a data conversion function, e.g. REMAP_DATA=EMP.EMPNO:REMAPPKG.EMPNO |