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

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply