exprec

来自「一本介绍oracle的书籍」· 代码 · 共 14 行

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