expdp 中的 include ，exlude 的具体用法 。

#!/bin/bash

source ~/.bash_profile

DATE=`date +%Y%m%d_%H%M%S`
PATH_DMP=/backup/dmp
PATH_LOG=/backup/dmp

expdp hello/world schemas=hello directory=data_dir exclude=TABLE:"LIKE'CON_%KLS%'" dumpfile=expdp_user_$DATE.dmp logfile=expdp_user_$DATE.log

date +"%Y-%m-%d %T" >> $PATH_LOG/expdp_user_$DATE.log
du -h $PATH_DMP/expdp_user_$DATE.dmp | awk '{print $1}' >> $PATH_LOG/expdp_user_$DATE.log

cd $PATH_DMP

tar zcvf expdp_user_$DATE.tar.gz expdp_user_$DATE.dmp
rm -rf expdp_user_$DATE.dmp

date +"%Y-%m-%d %T" >> $PATH_LOG/expdp_user_$DATE.log
du -h $PATH_DMP/expdp_user_$DATE.tar.gz | awk '{print $1}' >> $PATH_LOG/expdp_user_$DATE.log

DATE1=`date +%Y%m%d-%H%M%S`
PATH_DMP1=/backup/dmp
PATH_LOG1=/backup/dmp

expdp hello/world schemas=hello directory=data_dir include=TABLE:"LIKE'CON_%KLS%'" dumpfile=expdp_user_$DATE1.dmp logfile=expdp_user_$DATE1.log

date +"%Y-%m-%d %T" >> $PATH_LOG1/expdp_user_$DATE1.log
du -h $PATH_DMP1/expdp_user_$DATE1.dmp | awk '{print $1}' >> $PATH_LOG1/expdp_user_$DATE1.log

cd $PATH_DMP1

tar zcvf expdp_user_$DATE1.tar.gz expdp_user_$DATE1.dmp
rm -rf expdp_user_$DATE1.dmp

date +"%Y-%m-%d %T" >> $PATH_LOG1/expdp_user_$DATE1.log
du -h $PATH_DMP1/expdp_user_$DATE1.tar.gz | awk '{print $1}' >> $PATH_LOG1/expdp_user_$DATE1.log

find $PATH_DMP1 -name "expdp_user_*.tar.gz" -mtime +0 -exec rm {} \;
find $PATH_LOG1 -name "expdp_user_*.log"    -mtime +10 -exec rm {} \;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-706936/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/90618/viewspace-706936/