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
  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}]
  VERSION={COMPATIBLE | LATEST | version_string}

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.

Example

IMPDP system/password@sid full=Y directory=export_dir dumpfile=ss64.dmp logfile=imp_ss64.log

To import only a selection of schemas or tables, replace the full=Y in the above with schemas=USER1,USER2 or tables=TABLE1,TABLE2 etc

"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-2014
Some rights reserved