@文心快码ora-38029: object statistics are locked 文心快码 ORA-38029错误表示“对象统计信息已锁定”。 当尝试修改对象的优化器统计信息时,如果统计信息已被锁定,就会出现ORA-38029错误。这通常发生在执行如ANALYZE TABLE、CREATE INDEX、ALTER INDEX等操作时,如果相关对象的统计信息被锁定,这些操作将会失败。 解决...
ORA-38029: 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. ORA-38101: Invalid column in...
对象统计信息锁定的解决办法(ORA-20005/ORA-38029) 从9i R2里导出了几张表,然后导入到11g R2中,在导入成功后要收集下这些表的信息,结果发现好几张表都没法收集,用DBMS_STATS包显示ORA-20005:object statistics are locked (stattype = ALL),用Analyze命令显示ORA-38029: 对象统计信息已锁定。 解决办法很明确,就...
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later: ORA-38029 "Object Statistics Are Locked" - Possible Causes