IMPDP

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:

IMPDB system/password@sid schemas=SCOTT directory=export_dir dumpfile=ss64.dmp logfile=impSS64.log

Import selected tables:

IMPDB 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:

expdp - Export data with Oracle Data Pump.


© Copyright SS64.com 1999-2016
Some rights reserved