EXPDP/IMPDP WITHOUT TABLE DATA /META DATA ONLY


expdp system/s 
directory=backup_dir 
CONTENT=METADATA_ONLY 
dumpfile=testmetaddl.dmp 
schemas=testmeta 
logfile=testmetalog.$Date.log

impdp system/s 
directory=backup_dir 
dumpfile=testmetaddl.dmp 
sqlfile=metaddl.sql 
logfile=imp_log_of_meta.log

 

 
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

%d bloggers like this: