Skip to content

Instantly share code, notes, and snippets.

@zeraf29

zeraf29/impdb.sh

Created November 23, 2017 11:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zeraf29/cd76ba62be60ebf6c2a94a9e1f69b5a7 to your computer and use it in GitHub Desktop.
Save zeraf29/cd76ba62be60ebf6c2a94a9e1f69b5a7 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle impdb sample
Raw
impdb.sh
export IMPLOG=/oradir # directory for Import log
export DUMP_DATE=`date +%y%m%d` #making dumpdate
echo "schemas migration : " `date` >> $IMPLOG
impdp system/systempw directory=oradir content=metadata_only dumpfile=dumpfile.dmp logfile=logfile.log schemas=SCHEMA >> $IMPLOG
#for all export data, User system account.
#directory : What you create directory on Oracle upper step.
#CONTENT=METADATA_ONY : Only import metadata (not records)
#dumpfile : Dump file what you made using expdb in 'directory'
#logfile : making log file
#schemas : schema what you want importing
echo "========== END DATE : `date ` ======================= " >> $IMPLOG
echo
echo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment