exprec

一本介绍oracle的书籍

USER_PASSWD=dbuser/oracle
TABLE=user_info

mkdir -p dmp
cd dmp
rm -f *
cd ..

#conventional path
#exp $USER_PASSWD file=dmp/${TABLE}.dmp log=dmp/${TABLE}.log tables=${TABLE} buffer=4096000 feedback=10000

#direct path
exp $USER_PASSWD file=dmp/${TABLE}.dmp log=dmp/${TABLE}.log tables=${TABLE} direct=y feedback=10000