ORA-38029
来源:互联网 发布:天猫淘宝商城手机专卖 编辑:程序博客网 时间:2024/06/10 03:31
ORA-38029: 对象统计信息已锁定
随即查了一下——
-bash-3.00$ oerr ora 38029
38029, 00000, "object statistics are locked"
// *Cause: An attept was made to modify optimizer statistics of the object.
// *Action: Unlock statistics with the DBMS_STATS.UNLOCK_TABLE_STATS procedure
// on base table(s). Retry the operation if it is okay to update statistics.
于是就找UNLOCK_TABLE_STATS 的用法,在DBMS_STATS包中查找,也发现有UNLOCK_SCHEMA_STATS procedure,于是就干脆执行——
SQL> begin
2 DBMS_STATS.UNLOCK_schema_STATS(user);
3 end;
4 /PL/SQL 过程已成功完成。
exec dbms_stats.unlock_table_stats('CSHOW','cmpp_send_mass');
analyze table cmpp_send_mass compute statistics for table for all indexes for all indexed columns;
- ORA-38029 & ORA-20005
- ORA-38029
- oracle10g错误信息(ORA-38029~ORA-39961 )
- ORA
- ora
- ORA-38029:object statistics are locked
- 对象统计信息锁定的解决办法(ORA-20005/ORA-38029)
- 对象统计信息锁定的解决办法(ORA-20005/ORA-38029)
- ORA-01034 ORA-27101
- ORA-10567,ORA-00313
- ora-01128,ora-00275
- ORA-03113,ORA-07445
- ORA-32017 ORA-16179
- ORA-12012,ORA-12005
- ora-01034 ,ora-27101
- ora-603 ora-27504
- ora-01113 ora-01110
- ORA-24324 & ORA-01041
- ClassView not available的原因
- 排序
- RIA.AIR
- SIFT特征点匹配与消除错配:BBF,RANSAC
- JAVASCRIPT定义对象的四种方式
- ORA-38029
- [转]C语言系统资源控制(getrlimit && setrlimit)
- Spring的控制反转与依赖注入
- 数据导入
- 网页Css+Div排版常见问题总结
- JQuery的event事件对象详解
- vi中的tab操作
- Section 5.3 window area
- 21歲的感想