Oracle Utilities Pocket Reference

Name

impdp

Use impdp to load objects and data from a dumpfile created by the expdp utility into an Oracle database.

Tip

impdp is a new utility in Oracle Database 10g.

Syntax

impdp [login | sysdba_login] [paramval [paramval...]

login ::= username[/password][@net_service_name]]

sysdba_login ::= \'username/password AS SYSDBA\'

paramval ::= {parameter=one_value
            |parameter=(value1[,value2...]) }
parameter ::= {
  attach=[schema_name.]expdp_job
 |content={ALL | DATA_ONLY | METADATA_ONLY}
 |directory=dir_name
 |dumpfile=[directory_name:]file_name [, ...]
 |estimate={BLOCKS | STATISTICS}
 |exclude=object_type[:name_filter] [, ...]
 |flashback_scn=fscn
 |flashback_time=ftime
 |full={y|n}
 |help={y|n}
 |include=object_type[:name_filter] [, ...]
 |job_name=expdp_job
 |logfile=[directory_name:]log_name [, ...]
 |network_link=source_db_link
 |nologfile={y|n}
 |parallel=dop
 |parfile=parfile_name
 |query=q
 |remap_datafile=source_datafile:target_datafile
 |remap_schema=source_schema:target_schema
 |remap_tablespace=source_tablespace:target_tablespace
 |reuse_datafiles={y|n}
 |schemas=schema_name [, ...]
 |skip_unusable_indexes={y|n}
 |sqlfile=[directory_object:]file_name
 |status=interval
 |streams_configuration={y|n}
 |table_exists_action={SKIP|APPEND|TRUNCATE|REPLACE}
 |tables=[schema.]table[:partition] [, ...]
 |tablespaces=tablespace_name [, ...]
 |transform=transform_name:value[:object_type]
 |transport_datafiles=datafile_name
 |transport_full_check={y|n}
 |transport_tablespaces=tablespace_name [, ...] |version={COMPATIBLE | LATEST ...