C:\>exp scott/wellhope@orcl102 file=d:\daochu.dmp query=\"where ename like 'S%'\" tables=empExport: Release 10.1.0.2.0 - Production on 星期四 1月 6 11:01:00 2011Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc tion With the Partitioning, OLAP and Data Mining options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path ... . . exporting table EMP 2 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. Export terminated successfully with warnings.C:\>
exp system/manager@TEST file=d:\daochu.dmp tables=(table1) query=\" where filed1 like \'00\%\'\"; 这样修改下。试下。。
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path ...
. . exporting table EMP 2 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.C:\>
where filed1 like \'00\%\'\";
这样修改下。试下。。
导出成功终止, 但出现警告。
Export terminated successfully with warnings.
minitoy 的也是一样的
analyze table table1 compute statistics分析下表就可以了。。
G了下,在使用exp命令时候加上statistics=none,即不导出表的统计相关信息(注意导入后相关统计信息为空)。
如果忽略这个错误在imp的时候也没有影响。-The End-