Sunday 17 February 2019

EXPDP/IMPDP WITHOUT TABLE DATA (META DATA ONLY)

Export Schema without data (META DATA ONLY)

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

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

No comments:

Post a Comment