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