Oracle: Export (EXPDP) schema without data

Here is the quick tip to export schema without data. This is doable with option “CONTENT=METADATA_ONLY”.

Here is the sample example for the same.

EXPDP user_name/password DIRECTORY=backup_directory SCHEMAS=schema_name TABLESPACE=tablespace_name CONTENT=metadata_only

Go thru the following link for more details -> EXPDP (CONTENT)

Advertisements