Oracle: Export (EXPDP) schema without data

On By sqlpathyIn Uncategorized

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)

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s