Parameter comparison between oracle export and data pump

We know Oracle data pump is latest utility than oracle original export/import tool and also data pump comes with greater flexibility and more advantages. Those who are good at original export/import tool and new to oracle data pump, this post will help them specially to compare the differences between two.

Parameter Comparion between Oracle export/Import and data pump

Orginal Export Parameter	Comparable Data pump Parameter
BUFFER	In datapump equivalent parameter is not needed.
COMPRESS	In datapump equivalent parameter is not needed
CONSISTENT	In datapump FLASHBACK_SCN and FLASHBACK_TIME do the job.
CONSTRAINTS	EXCLUDE=CONSTRAINT
DIRECT	Data pump automatically choose direct path or external tables mode.
FEEDBACK	STATUS
FILE	DUMPFILE
FILESIZE	FILESIZE
FLASHBACK_SCN	FLASHBACK_SCN
FLASHBACK_TIME	FLASHBACK_TIME
FULL	FULL
GRANTS	EXLUDE=GRANT
HELP	HELP
INDEXES	EXCLUDE=INDEX
LOG	LOGFILE
OBJECT_CONSISTENT	Equivalent parameter is not needed.
OWNER	SCHEMAS
PARFILE	PARFILE
QUERY	QUERY
RECORDLENGTH	Equivalent parameter is not needed.
RESUMABLE	This function is automatically enabled for user who has been granted EXP_FULL_DATABASE role.
RESUMABLE_NAME	This function is automatically enabled for user who has been granted EXP_FULL_DATABASE role.
RESUMABLE_TIMEOUT	This function is automatically enabled for user who has been granted EXP_FULL_DATABASE role.
ROWS=N	CONTENT=METADATA_ONLY
ROWS=Y	CONTENT=ALL
STATISTICS	Not needed. Statistics are always saved for tables.
TABLES	TABLES
TABLESPACES	It has TABLESPACES parameter but behave differently than original export.

Related Documents

Original Export and Import Versus Data Pump Export and Import

Export/Import from Enterprise Manager
Original Export/Import