EXPDP metadata(DDLs) and data with content option

Export the metadata and data only with CONTENT option in EXPDP datapump

For EXPDP Metadata only:
It will export the metadata of the schema excluding the data.
expdp HR@ORCL directory=DBBACKUP dumpfile=HR.dmp logfile=HR.log content=METADATA_ONLY

For EXPDP data only:
It will export the data only, it will not create the schema with metadata, it only used for import data which already has similar schema structure.
expdp HR@ORCL directory=DBBACKUP dumpfile=HR.dmp logfile=HR.log content=DATA_ONLY

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.