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
