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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s