我的shell脚本如下:
while read mt
do
if [ -z "$m" ]; then
m=$mt
fi
m=$mt,$m
export m
#echo $m
done < mytable.txt
#mytable.txt里面存放的表的名字,一行一个表
exp odsdev/odsdev@odsdev235 tables=($m) buffer=1048575 file=my.dmp compress=y报错提示信息是:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bitn
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified tables via Conventional Path ...
. . exporting table BND 3850 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ERH 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table IAL 1865 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table FIV 8 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
请各位看看是什么错,应该怎么解决。
while read mt
do
if [ -z "$m" ]; then
m=$mt
fi
m=$mt,$m
export m
#echo $m
done < mytable.txt
#mytable.txt里面存放的表的名字,一行一个表
exp odsdev/odsdev@odsdev235 tables=($m) buffer=1048575 file=my.dmp compress=y报错提示信息是:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bitn
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified tables via Conventional Path ...
. . exporting table BND 3850 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ERH 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table IAL 1865 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table FIV 8 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
请各位看看是什么错,应该怎么解决。
server uses ZHS16GBK character set (possible charset conversion) 同意1楼的,楼主在导出之前先将字符集修改成ZHS16GBK 看看..
这里没有错误,不过是有些warning,根据这里的提示应该是statistics有问题。你导出的时候,可以加上statistics=none试试。
--问题描述及解答!同楼上几位一致!