Oracle Utilities Pocket Reference

Name

expdp

Use expdp to extract data and metadata from an Oracle database into an operating system file in order to transport that data to another Oracle database, copy objects and data from one schema to another, or detect block corruption.

Tip

expdp is a new utility in Oracle Database 10g.

Syntax

expdp [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}
    |estimate_only={y|n}
    |exclude=object_type[:name_filter] [, ...]
    |filesize=fsize[B | K | M | G]
    |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
    |schemas=schema_name [, ...]
    |status=interval
    |tables=[schema.]table[:partition] [, ...]
    |tablespaces=tablespace_name [, ...]
    |transport_full_check={y|n}
    |transport_tablespaces=tablespace_name [, ...]
    |version={COMPATIBLE | LATEST | version_string}

Parameters

attach=[schema_name.]expdp_job

Specifies the name of the (already running) data pump export the client will be attached to. If you want your client to attach to a job in a schema other than ...