停止空想

老张的空中之家

存档于 ‘Oracle’ 分类

解决 oracle EXP-00091: Exporting questionable statistics. 问题(转)

作者:admin 发表时间:三月 - 27 - 2009

EXP-00091 Exporting questionable statistics

Cause: 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.

解决:
linux下的oracle用户的环境变量语言集和oralce数据库中的环境变量语言集不相同。
查看oracle的环境变量语言集:
数据库服务器字符集:
select * from nls_database_parameters
客户端字符集:
select * from nls_instance_parameters

将oracle用户的环境变量语言集改成和数据库服务器字符集一样。
export NLS_LANG=american_america.ZHS16GBK

类别:Oracle

创建基于函数的index需要什么权限?

作者:admin 发表时间:三月 - 18 - 2009

create index IDX_F_DEP on T_DEPARTMENT (SUBSTR(C_INTER_CDE,1,2))
*
ERROR at line 1:
ORA-01031: insufficient privileges

确认需要有两个权限, 一个是create any index

另一个是global query rewrite

类别:Oracle

Oracle的临时文件号在系统中的标识

作者:admin 发表时间:三月 - 11 - 2009

今天发现系统中有大量的direct path read 等待事件,
SID P1 P1TEXT P2 P2TEXT P3 P3TEXT
———- ———- ———- ———- ———- ———- ———-
1142 2006 file number 75847 first dba 31 block cnt

473 2006 file number 40163 first dba 15 block cnt

458 2006 file number 59333 first dba 15 block cnt
阅读全文 »

类别:Oracle