测试数据导入,采集统计信息的时候,提示错误信息,使用oerr检索错误号,无此错误号解释。
SQL> exec dbms_stats.gather_table_stats('USER_A','A',cascade=>true);
BEGIN dbms_stats.gather_table_stats('USER_A','A',cascade=>true); END;
*
ERROR at line 1:
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 24281
ORA-06512: at "SYS.DBMS_STATS", line 24332
ORA-06512: at line 1
检索MOS有这个错误号的信息,意思就是统计信息被锁了,
ORA-20005 reported on Queue Table Statistics Collection (文档 ID 558187.1)
"ORA-20005: object statistics are locked" Error When Executing gather_table_stats.sql Script (文档 ID 967050.1)
我们