Skip to content

Instantly share code, notes, and snippets.

@zeraf29

zeraf29/expdb.sh

Last active November 23, 2017 11:42
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/2c0a76bcb95744a9062e690a6bb450cc to your computer and use it in GitHub Desktop.
Save zeraf29/2c0a76bcb95744a9062e690a6bb450cc to your computer and use it in GitHub Desktop.
Download ZIP
Oracle expdb sample
Raw
expdb.sh
expdp system/systempw directory=oradir dumpfile=oraback.dmp logfile=exp.log schemas=SCHEMANAME CONTENT=METADATA_ONLY
#for all export data, User system account.
#directory : What you create directory on Oracle upper step.
#dumpfile : Dump file will be made using this name on 'dirtory' location
#logfile : making log file
#schemas : select schema what you want exporting
#CONTENT=METADATA_ONY : Only export metadata (not records)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment