Oracle Utilities Pocket Reference

Name

imp

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

Tip

Like exp, imp can be executed in one of four modes: full, user, tablespace, and table.

Syntax

imp [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
    |commit={y|n}
    |compile={y|n}
    |constraints={y|n}
    |datafiles=filename
    |destroy={y|n}
    |feedback=f
    |file=fname1 [,fname2 [,fname3 ... ]]
    |filesize=fsize
    |fromuser=fuser1 [,fuser2 [,fuser3 ... ]]
    |full={y|n}
    |grants={y|n}
    |help={y|n}
    |ignore={y|n}
    |indexes={y|n}
    |indexfile=indfile
    |log=log_name
    |parfile=parfile_name
    |recordlength=rlen
    |resumable={y|n}
    |resumable_name=res_name
    |resumable_timeout=res_time
    |rows={y|n}
    |show={y|n}
    |skip_unusable_indexes={y|n}
    |statistics={ALWAYS|NONE|SAFE|RECALCULATE}
    |streams_configuration={y|n}
    |streams_instantiation={y|n}
    |tables=table_spec
    |tablespaces=tspace1 [,tspace2 [,tspace3 ... ]]
    |toid_novalidate=([schemaname.]typename [, ...])
    |touser=tuser1 [,tuser2 [,tuser3 ... ]]
    |transport_tablespace={y|n}
    |tts_owners=towner1 [,towner2 [,towner3 ... ]]
    |userid=username/password[@net_service_name] [AS
SYSDBA]
    |volsize=vsize}

Parameters

The following parameters are the same as for exp:

buffer	constraints
feedback	file
filesize	full
grants	help
indexes	log
parfile	recordlength
resumable	resumable_name
resumable_timeout	rows
statistics ...