Oracle EXP / IMP arguments detailed

Posted on 2010-01-27 filed under: Oracle (RSS) 23 views

exp / imp is Oracle's own import and export command, use it, even if that statement does not require UI tool can easily export the data into the completion of the work, the following are their parameters:

EXP arguments detailed <br /> use format: EXP KEYWORD = value or KEYWORD = (value1, value2 ,..., valueN)
Where USERID is necessary and for the first parameter

Keyword	Notes
USERID	User Name / Password
FULL	Exporting the entire file (N)
BUFFER	Data buffer size of the
OWNER	Owner user name list
FILE	Output file (EXPDAT.DMP)
TABLES	Table Name List
COMPRESS	Into a range of (Y)
RECORDLENGTH	Record the length of the IO
GRANTS	Export privileges (Y)
INCTYPE	Incremental export type
INDEXES	Export Index (Y)
RECORD	Track incremental export (Y)
ROWS	Export data rows (Y)
PARFILE	Parameter File Name
CONSTRAINTS	Export restriction (Y)
CONSISTENT	Cross-table consistency
LOG	The screen output log file
STATISTICS	Analysis of objects (ESTIMATE)
DIRECT	Direct path (N)
TRIGGERS	Export triggers (Y)
FEEDBACK	Display each x-line (0) the progress of the
FILESIZE	The maximum size of each dump file
QUERY	Export Table selected subset of the clauses
The following keywords are used only for table spaces that can be transmitted
TRANSPORT_TABLESPACE	Export the table that can be transmitted spatial metadata (N)
TABLESPACES	The transfer list of the table space

IMP arguments detailed
The format used is: IMP KEYWORD = value or KEYWORD = (value1, value2 ,..., valueN)
Where USERID is necessary and for the first parameter

Keyword	Notes
USERID	User Name / Password
FULL	Import the entire file (N)
BUFFER	Data Buffer Size
FROMUSER	Owner user name list
TOUSER	User Name List
FILE	Input file (EXPDAT.DMP)
SHOW	List only the contents of the file (N)
TABLES	Table Name List
IGNORE	Ignore create errors (N)
RECORDLENGTH	Record the length of the IO
GRANTS	Import permission (Y)
INCTYPE	Incremental import type
INDEXES	Import Index (Y)
COMMIT	Presented an array insert (N)
ROWS	Import data rows (Y)
PARFILE	Parameter File Name
LOG	The screen output log file
CONSTRAINTS	Import restrictions (Y)
DESTROY	Cover the table space data file (N)
INDEXFILE	Table / index information write to the specified file
SKIP_UNUSABLE_INDEXES	Skip index maintenance is not available (N)
FEEDBACK	Line shows the progress of each x (0)
TOID_NOVALIDATE	Skip the specified types of ID verification
FILESIZE	The maximum size of each dump file
STATISTICS	Always import precomputed statistics
RESUMABLE	In the event of space-related error hangs (N)
RESUMABLE_NAME	Recoverable statement used to identify text strings
RESUMABLE_TIMEOUT	RESUMABLE waiting time
COMPILE	Compilation process, package and functions (Y)
STREAMS_CONFIGURATION	Flow into the general metadata (Y)
STREAMS_INSTANTIATION	Import current instantiation metadata (N)
The following keywords are used only for table spaces that can be transmitted
TRANSPORT_TABLESPACE	Import the table that can be transmitted spatial metadata (N)
TABLESPACES	Will be transferred to the database table space
DATAFILES	Will be transmitted to the database data files
TTS_OWNERS	Have a centralized data can be transmitted to the user tablespace