我两台服务器是这样装的:
linux 下装的是oracle 10g 1.0.3
windows 2003 下装的是oracle 10g 1.0.2
数据库编码格式都是utf-8
目的是:实现两台系统数据库相互备份当我从windows下通过
exp 用户名/密码@名称(配置正确) file='c:\test.dmp'
导出时提示很多exp-00091警告,请问这样对数据记录是否会丢失?
linux 下装的是oracle 10g 1.0.3
windows 2003 下装的是oracle 10g 1.0.2
数据库编码格式都是utf-8
目的是:实现两台系统数据库相互备份当我从windows下通过
exp 用户名/密码@名称(配置正确) file='c:\test.dmp'
导出时提示很多exp-00091警告,请问这样对数据记录是否会丢失?
这个错误产生原因是表数据的统计信息和当前表实际信息不一致,应该不会丢失数据如果不想看到这个警告,可以通过添加参数STATISTICS=NONE 来进行屏蔽STATISTICS 参数是指是否导入数据表、索引的统计信息,
取值范围:COMPUTE (统计值)、ESTIMATE (估算值)、NONE (不导出)
默认值: ESTIMATE
err exp 91
00091, 00000, "Exporting questionable statistics."
*Cause: Export was able export statistics, but the statistics may not be
usuable. The statistics are questionable because one or more of
the following happened during export: a row error occurred, client
character set or NCHARSET does not match with the server, a query
clause was specified on export, only certain partitions or
subpartitions were exported, or a fatal error occurred while
processing a table.
*Action: To export non-questionable statistics, change the client character
set or NCHARSET to match the server, export with no query clause,
export complete tables. If desired, import parameters can be
supplied so that only non-questionable statistics will be imported,
and all questionable statistics will be recalculated.
我没用过10,oralce9肯定不能导oracle8的内容。