1、select * from nls_database_parameters;
or select * from V$NLS_PARAMETERS;
2、EXP-00091 Exporting questionable statisticsCause: Export was able to export statistics, but the statistics may not be useable. 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, or 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.
or select * from V$NLS_PARAMETERS;
2、EXP-00091 Exporting questionable statisticsCause: Export was able to export statistics, but the statistics may not be useable. 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, or 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.
解决方案 »
- 为什么我的oracle11g没有net manager,那么我怎么配置监听?
- oracle8i
- 请教一个触发器的写法!
- Toad for oracle的使用问题
- Oracel触发器插入之前修改更新字段,求助
- 有没有不用装客户端的工具??
- 关于导入导出的问题... ...
- 如何使用户在pl/sql中用户新建一个过程或表等时,弹出一输入框输入一些信息?
- oracle8.05+develop2000开发的程序在oracle9i+oracle6i下为什么不能运行?
- OEM的设置问题
- 为什么我的ORACLE命令只能在$ORACLE_HOME\BIN目录下运行?
- 关于dba studio 的登陆问题,选中一个数据库后,如果登陆身份设为dba,,密码不对也能进,为什么呢?
你应该是用客户端来EXP的,这样需要两边的字符级要相等,
建议还是在服务端EXP,再IMP
数据库的字符集是UTF8
国家语言字符集是AL16UTF16
导出时,由UTF8向WE8MSWIN1252做了转换,因此可能会有问题。
from nls_database_parameters;
查数据库的相关设置