Export-Import

Export :

Keyword	Description (Default)
USERID	username/password
BUFFER	size of data buffer
FILE	output file (EXPDAT.DMP)
COMPRESS	import into one extent (Y)
GRANTS	export grants (Y)
INDEXES	export indexes(Y)
ROWS	export data rows (Y)
CONSTRAINTS	export table constraints (Y)
CONSISTENT	cross-table consistency (N)
LOG	log file of screen output (None)
STATISTICS	analyze objects (ESTIMATE)
DIRECT	Bypass the SQLcommand processing layer (N) (new in Oracle8)
FEEDBACK	Show a process meter (a dot) every X rows exported (0 – Xvalue)
HELP	Shows help listing
MLS	MLS_LABEL_FORMAT  Used with secure Oracle; we won't cover these.
FULL	export entire file (N)
OWNER	list of owner usernames
TABLES	list of table names
RECORDLENGTH	length of IO record
INCTYPE	incremental export type
RECORD	track incr. export (Y)
PARFILE	parameter file name

IMPORT

Keyword	Description (Default)
USERID	username/password
BUFFER	size of data buffer
FILE	Output file (EXPDAT.DMP)
SHOW	just list file contents (N)
IGNORE	Ignore create errors (N)
RECORDLENGTH	length of IOrecord
GRANTS	Import grants (Y)
INDEXES	Import indexes (Y)
ROWS	Import data rows (Y)
LOG	log file of screen output
INDEXFILE	write table/index info to specified file
FULL	Import entire file (N)
FROMUSER	list of owner usernames
TOUSER	list of usernames
TABLES	list of table names
FEEDBACK	Provide dot status graph (0)
INCTYPE	incremental import type
COMMIT	commit array insert (N)
PARFILE	parameter file name
DESTROY	overwrite tablespace data (N)
CHARSET	char. set of export file (NLS_LANG)

EXPORT DP

Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

Keyword	Description(Default)
ATTACH	Attach to existing job, e.g. ATTACH [=job name].
CONTENT	(ALL), DATA_ONLY, and METADATA_ONLY
DIRECTORY	Directory object to be used for dumpfiles and logfiles
DUMPFILE	List of destination dump files (expdat.dmp),
ESTIMATE	(BLOCKS) and STATISTICS
ESTIMATE_ONLY	Calculate job estimates without performing the export
EXCLUDE	Exclude specific object types, e.g. EXCLUDE=TABLE:EMP
FILESIZE	Specify the size of each dumpfile in units of bytes
FLASHBACK_SCN	SCN used to set session snapshot back to
FLASHBACK_TIME	Time used to get the SCN closest to the specified time
FULL	Export entire database (N).
HELP	Display Help messages (N).
INCLUDE	Include specific object types, e.g. INCLUDE=TABLE_DATA.
JOB_NAME	Name of export job to create
LOGFILE	Log file name (export.log).
NETWORK_LINK	Name of remote database link to the source system
NOLOGFILE	Do not write logfile (N).
PARALLEL	Change the number of active workers for current job
PARFILE	Specify parameter file
QUERY	Predicate clause used to export a subset of a table.
SCHEMAS	List of schemas to export (login schema).
STATUS	Frequency (secs) job status is to be monitored where the default (0) will show new status when available.
TABLES	Identifies a list of tables to export - one schema only.
TABLESPACES	Identifies a list of tablespaces to export.
TRANSPORT_FULL_CHECK	Verify storage segments of all tables (N).
TRANSPORT_TABLESPACES	List of tablespaces from which metadata will be unloaded.
VERSION	(COMPATIBLE), LATEST, or any valid database version.

IMPORT DP

Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

Keyword	Description(Default)
ATTACH	Attach to existing job, e.g. ATTACH [=job name].
CONTENT	(ALL), DATA_ONLY, and METADATA_ONLY
DIRECTORY	Directory object to be used for dumpfiles and logfiles
DUMPFILE	List of destination dump files (expdat.dmp),
ESTIMATE	(BLOCKS) and STATISTICS
ESTIMATE_ONLY	Calculate job estimates without performing the export
EXCLUDE	Exclude specific object types, e.g. EXCLUDE=TABLE:EMP
FILESIZE	Specify the size of each dumpfile in units of bytes
FLASHBACK_SCN	SCN used to set session snapshot back to
FLASHBACK_TIME	Time used to get the SCN closest to the specified time
FULL	Export entire database (N).
HELP	Display Help messages (N).
INCLUDE	Include specific object types, e.g. INCLUDE=TABLE_DATA.
JOB_NAME	Name of export job to create
LOGFILE	Log file name (export.log).
NETWORK_LINK	Name of remote database link to the source system
NOLOGFILE	Do not write logfile (N).
PARALLEL	Change the number of active workers for current job
PARFILE	Specify parameter file
QUERY	Predicate clause used to export a subset of a table.
SCHEMAS	List of schemas to export (login schema).
STATUS	Frequency (secs) job status is to be monitored where the default (0) will show new status when available.
TABLES	Identifies a list of tables to export - one schema only.
TABLESPACES	Identifies a list of tablespaces to export.
TRANSPORT_FULL_CHECK	Verify storage segments of all tables (N).
TRANSPORT_TABLESPACES	List of tablespaces from which metadata will be unloaded.
VERSION	(COMPATIBLE), LATEST, or any valid database version.
REMAP_DATAFILE	Redefine datafile references in all DDL statements
REMAP_SCHEMA	Objects from one schema are loaded into another schema.
REMAP_TABLESPACE	Tablespace object are remapped to another tablespace.
REUSE_DATAFILES	Tablespace will be initialized if it already exists (N).
SKIP_UNUSABLE_INDEXES	Skip indexes that were set to the Index Unusable state.
SQLFILE	Write all the SQL DDL to a specified file.
STREAMS_CONFIGURATION	Enable the loading of Streams metadata.
TABLE_EXISTS_ACTION	Valid keywords: (SKIP), APPEND, REPLACE and TRUNCATE.
TRANSFORM	Metadata transform to apply (Y/N) to specific objects.
TRANSPORT_DATAFILES	List of datafiles to be imported by transportable mode.