table definitions
table data
table indexes
integrity constraints
triggers.
To do a full import a user needs the system privilege imp_full_database otherwise to import into their own schema resource will do.
imp username/password@instance parfile=xxxxx
Example import of selected tables for a specific user
imp FILE=dba.dmp IGNORE=y GRANTS=y FROMUSER=scott TABLES=(dept,emp)
Example Import of Tables from One User to Another
imp FILE=scott.dmp FROMUSER=scott TOUSER=blake TABLES=(*)
Example Import of Using Pattern Matching to Import Various Tables
imp FILE=scott.dmp IGNORE=y GRANTS=y ROWS=y FROMUSER=scott TABLES=(%d%,b%s)
ANALYZE execute ANALYZE statements in dump file (Y)
BUFFER size of data buffer
COMMIT commit array insert (N)
CONSTRAINTS import constraints (Y)
DATAFILES datafiles to be transported into database
DESTROY overwrite tablespace data file (N)
FEEDBACK display progress every x rows(0)
FILE input files (EXPDAT.DMP)
FILESIZE maximum size of each dump file
FROMUSER list of owner usernames
FULL import entire file (N)
GRANTS import grants (Y)
IGNORE ignore create errors and allows rows to be imported to tables that already exist(N)
INCTYPE incremental import type
INDEXFILE write table/index info to specified file
INDEXES import indexes (Y)
LOG log file of screen output
PARFILE parameter filename
RECALCULATE_STATISTICS recalculate statistics (N)
RECORDLENGTH length of IO record
ROWS import data rows (Y)
SHOW just list file contents (N)
SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)
TABLES list of table names
TOID_NOVALIDATE skip validation of specified type ids
TOUSER list of usernames
USERID username/password
VOLSIZE number of bytes in file on each volume of a file on tape
The following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE import transportable tablespace metadata (N)
TABLESPACES tablespaces to be transported into database
TTS_OWNERS users that own data in the transportable tablespace set