cat exp.lst |while read line
do
echo "正在导出表:$line"
exp qhucrm1o/ddd123@qhcrmdb file=/crm_arch2/DMP/$line.dmp log=/crm_arch2/DMP/log/$line.log tables=$line compress=y direct=y feedback=10000 buffer=100000000
imp qhucrm1o/qhucrm1o@crmdb rows=y ignore=y tables=$line indexes=y commit=y file=/crm_arch2/DMP/$line.dmp log=/crm_arch2/DMP/imp/log/$line.log
rm -f $line
echo "$line表已导出完成"
done
请指正
do
echo "正在导出表:$line"
exp qhucrm1o/ddd123@qhcrmdb file=/crm_arch2/DMP/$line.dmp log=/crm_arch2/DMP/log/$line.log tables=$line compress=y direct=y feedback=10000 buffer=100000000
imp qhucrm1o/qhucrm1o@crmdb rows=y ignore=y tables=$line indexes=y commit=y file=/crm_arch2/DMP/$line.dmp log=/crm_arch2/DMP/imp/log/$line.log
rm -f $line
echo "$line表已导出完成"
done
请指正
这个快慢不是SHELL的问题吧。