Explanation of EXP and IMP commands in oracle

Command details: E:/> exp help = y by entering the EXP command and user name/password, you can
Command after user/password: instance: exp scott/TIGER or, you can also control the "Export" running mode by entering the EXP command with various parameters.
To specify parameters, you can use the KEYWORD: Format: exp keyword = value or KEYWORD = (value1, value2,..., valueN)
Instance: exp scott/tiger grants = y tables = (EMP, DEPT, MGR)
Or TABLES = (T1: P1, T1: P2). If T1 is a partition table, USERID must be the first parameter in the command line. Keyword description (default)
---------------------------------------------------
USERID username/password
FULL export the entire file (N)
BUFFER data BUFFER size
OWNER username list
FILE output FILE (EXPDAT. DMP)
TABLES Table Name List
COMPRESS imports a range (Y)
Recordlength io record length
GRANTS export permission (Y)
INCTYPE incremental export type
INDEXES export index (Y)
Incremental export of RECORD tracking (Y)
ROWS export data ROWS (Y)
PARFILE parameter file name
CONSTRAINTS export limit (Y)
CONSISTENT cross tabulation consistency
LOG File output by LOG Screen
STATISTICS Analysis object (ESTIMATE)
DIRECT path (N)
TRIGGERS export trigger (Y)
FEEDBACK displays the progress of each x row (0)
FILESIZE maximum size of each dump file
QUERY the clause of the selected exported table subset. The following keywords are used only for the table space that can be transferred.
TRANSPORT_TABLESPACE export the table space metadata that can be transferred (N)
TABLESPACES table space list to be transmitted e:/> imp help = y you can enter the IMP command and your user name/Password
Command with your username/password: instance: imp scott/TIGER or, you can control "import" by entering the IMP command and various independent variables according to different parameters.
To specify parameters, you can use the Keyword: Format: IMP keyword = value or keyword = (value1, value2,..., vlauen)
Instance: IMP Scott/tiger ignore = y tables = (EMP, Dept) Full = N
Or tables = (T1: P1, T1: P2). If T1 is a partition table, userid must be the first parameter in the command line. Keyword description (default)
----------------------------------------------
Userid username/password
Full import of the entire file (N)
Buffer data buffer size
Fromuser User Name List
File input file (expdat. dmp)
Touser User Name List
Show only lists file content (N)
Tables Table Name List
Ignore ignore creation error (N)
Recordlength Io record length
Grants import permission (y)
Inctype incremental Import Type
Indexes import index (y)
COMMIT submits array insert (N)
ROWS import data ROWS (Y)
PARFILE parameter file name
LOG File output by LOG Screen
CONSTRAINTS import restrictions (Y)
DESTROY overwrite the tablespace data file (N)
INDEXFILE writes table/index information to the specified file
SKIP_UNUSABLE_INDEXES skips maintenance of unavailable indexes (N)
ANALYZE executes the ANALYZE Statement (Y) in the dump file)
FEEDBACK displays the progress of each x row (0)
TOID_NOVALIDATE skips the verification of the specified type id
FILESIZE maximum size of each dump file
RECALCULATE_STATISTICS recalculates the statistical value (N). The following keywords are used only for the table space that can be transferred.
TRANSPORT_TABLESPACE import the deletable tablespace metadata (N)
TABLESPACES tablespace to be transmitted to the database
Data files to be transmitted to the database
TTS_OWNERS users who have the ability to transmit data in a tablespace Set Source: http://pstman.blog.51cto.com/156886/28344