Oracle Utilities Pocket Reference

Name

exp

Use exp to extract data and metadata from an Oracle database into an operating system file for the purpose of transport to another Oracle database, copying objects and data from one schema to another, or for detecting block corruption.

Tip

Using Oracle Database 10g? Use expdp (Data Pump Export) instead.

Syntax

exp [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 ::= {
     buffer=[size_in_bytes]
    |compress={y|n}
    |consistent={y|n}
    |constraints={y|n}
    |direct={y|n}
    |feedback=f
    |file=fname1 [,fname2 [,fname3 ... ]]
    |filesize=fsize
    |flashback_scn=fscn
    |flashback_time=ftime
    |full={y|n}
    |grants={y|n}
    |help={y|n}
    |indexes={y|n}
    |log=log_name
    |object_consistent={y|n}
    |owner=owner1 [,owner2 [,owner3 ... ]]
    |parfile=parfile_name
    |query=q
    |recordlength=rlen
    |resumable={y|n}
    |resumable_name=res_name
    |resumable_timeout=res_time
    |rows={y|n}
    |statistics={ESTIMATE|COMPUTE|NONE}
    |tables=table1[,table2 [,table3... ]]
    |tablespaces=tspace1 [,tspace2 [,tspace3 ... ]]
    |transport_tablespace={y|n}
    |triggers={y|n}
    |tts_full_check={y|n}
    |userid=username/password[@net_service_name] [AS
SYSDBA]
    |volsize=vsize}

Parameters

buffer=size_in_bytes

Specifies the size of the buffer (memory) used to fetch rows. The number of rows fetched at a time from the table is equal to the buffer size divided by the maximum row size for the table. The larger the ...