Oracle export, import parameters explained

1. Common Import and Export commands:imp (Import), exp (export)

CMD-based Export import:

Key words	Note
Userid	User name/password
Full	Export entire file (N)
BUFFER	Size of the data buffer
OWNER	List of owner user names
FILE	Output file (Expdat. DMP)
TABLES	List of table names
COMPRESS	Import a range (Y)
RecordLength	Length of IO record
GRANTS	Export Permissions (Y)
Inctype	Incremental export Type
INDEXES	Export Index (Y)
RECORD	Trace incremental Export (Y)
ROWS	Export data rows (Y)
Parfile	Parameter file name
CONSTRAINTS	Export Limit (Y)
Consistent	Cross-table consistency
LOG	Log file for screen output
STATISTICS	Analytical Objects (ESTIMATE)
DIRECT	Direct Path (N)
TRIGGERS	Export Trigger (Y)
FEEDBACK	Shows the progress of each x line (0)
FILESIZE	Maximum size of each dump file
QUERY	Select the clause that exports a subset of tables
The following keywords are only available for transportable tablespaces
Transport_tablespace	Export the transportable tablespace metadata (N)
Tablespaces	List of table spaces to transfer

IMP parameter details
Used in the format: IMP keyword=value or keyword= (value1,value2,..., Valuen)
Where UserID is required and is the first parameter

Key words	Note
Userid	User name/password
Full	Import entire file (N)
BUFFER	Data buffer size
Fromuser	List of owner user names
Touser	List of user names
FILE	Input file (Expdat. DMP)
SHOW	List only file contents (N)
TABLES	List of table names
IGNORE	Ignore create error (N)
RecordLength	Length of IO record
GRANTS	Import permissions (Y)
Inctype	Incremental import Type
INDEXES	Import index (Y)
COMMIT	Commit array insertion (N)
ROWS	Import data rows (Y)
Parfile	Parameter file name
LOG	Log file for screen output
CONSTRAINTS	Import Limit (Y)
DESTROY	Overwrite tablespace data file (N)
Indexfile	Writes table/index information to the specified file
Skip_unusable_indexes	Skipping maintenance of indexes that are not available (N)
FEEDBACK	Show progress per X line (0)
Toid_novalidate	Skipping validation of a specified type ID
FILESIZE	Maximum size of each dump file
STATISTICS	Always import precomputed statistics
Resumable	Hang (N) when encountering space-related errors
Resumable_name	The text string used to identify the recoverable statement
Resumable_timeout	Resumable of waiting time
COMPILE	Compilation procedures, packages and functions (Y)
Streams_configuration	Generic metadata for the import stream (Y)
Streams_instantiation	Import Stream instantiation metadata (N)
The following keywords are only available for transportable tablespaces
Transport_tablespace	Import transportable tablespace metadata (N)
Tablespaces	Table space to be transferred to the database
Datafiles	Data files that will be transferred to the database
Tts_owners	Users who have data in a dataset that can transmit a table space

Oracle export, import parameters explained