Import data with Oracle Data Pump.
Syntax:
IMPDP username/password@connect_string [AS SYSDBA] ATTACH [=[schema_name.]job_name]
IMPDP username/password@connect_string [AS SYSDBA] FULL=Y options
IMPDP username/password@connect_string [AS SYSDBA] SCHEMAS=schema_name
[,schema_name2...] options
IMPDP username/password@connect_string [AS SYSDBA] TABLES=[schema_name.]table_name [:partition_name]
[,table_name2...] options
IMPDP username/password@connect_string [AS SYSDBA] TABLESPACES=tablespace_name
[,tablespace_name2...] options
IMPDP username/password@connect_string [AS SYSDBA] TRANSPORT_DATAFILES=datafile_name
[,datafile_name2...] options
IMPDP help=Y
Options
CONTENT={ ALL | DATA_ONLY | METADATA_ONLY }
DIRECTORY=directory_object
DUMPFILE=[directory_object:]file_name [,[directory_object:]file_name...]
ESTIMATE={ BLOCKS | STATISTICS}
ENCRYPTION_PASSWORD=password
EXCLUDE = object_type [:name_clause] [, EXCLUDE...]
FLASHBACK_SCN=scn_value
FLASHBACK_TIME=timestamp
INCLUDE = object_type [:name_clause] [, INCLUDE...]
JOB_NAME=jobname_string
LOGFILE=[directory_object:]file_name
NETWORK_LINK=database_link
NOLOGFILE={Y|N}
PARALLEL=int
PARFILE=[directory_path]file_name The name of an import parameter file.
QUERY=[schema_name.][table_name:]query_clause
REUSE_DATAFILES={Y|N}
REMAP_DATAFILE=source_datafile:target_datafile
REMAP_SCHEMA=source_schema:target_schema
REMAP_TABLESPACE=source_tablespace:target_tablespace
SKIP_UNUSABLE_INDEXES={Y|N}
SQLFILE=[directory_object:]file_name
STREAMS_CONFIGURATION={Y|N}
STATUS [=int]
TABLE_EXISTS_ACTION={SKIP | APPEND | TRUNCATE | REPLACE }
TRANSFORM={ SEGMENT_ATTRIBUTES | STORAGE | OID | PCTSPACE}:value[:object_type]
TRANSPORT_TABLESPACES = tblspace_name [,tblspace_name...] [TRANSPORT_FULL_CHECK ={Y|N}]
USERID=username The username performing the import, don’t confuse with SCHEMAS=schema_name.
VERSION={COMPATIBLE | LATEST | version_string}
Options can be supplied as part of the IMPDP command line or within an import parameter file.
On the command line, the Username (or USERID) must be the first parameter.
Interactive mode options:
CONTINUE_CLIENT Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT Quit client session and leave job running.
HELP Summarize interactive commands.
KILL_JOB Detach and delete job.
PARALLEL Change the number of active workers for current job.
PARALLEL=.
START_JOB Start/resume current job.
STATUS Frequency (secs) job status is to be monitored where
the default (0) will show new status when available.
STATUS=integer
STOP_JOB Orderly shutdown of job execution and exits the client.
STOP_JOB=IMMEDIATE performs an immediate shutdown of the
Data Pump job.
IMPDP is a server side utility for loading an export dump file set into a target system.
A dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. IMPDP can also be used to load a target database directly from a source database with no intervening dump files. This allows export and import operations to run concurrently, minimizing total elapsed time. This is known as a network import.
Examples
Full import:
IMPDP system/password@sid full=Y directory=export_dir dumpfile=ss64.dmp logfile=impSS64.log
Import a single schema:
IMPDP system/password@sid schemas=SCOTT directory=export_dir dumpfile=ss64.dmp logfile=impSS64.log
Import selected tables:
IMPDP system/password@sid tables=EMP,DEPT directory=export_dir dumpfile=ss64.dmp logfile=ImpSS64.log
"It's part of a trilogy, a musical trilogy that I’m doing in D minor which I always find is really the saddest of all keys really, I don’t know why but it makes people weep instantly...” ~ Spinal Tap
Related Oracle Commands:
expdp - Export data with Oracle Data Pump.