-
Title
Reorg failed with "ORA-20005: object statistics are locked" -
Description
Reorg failed with following:
[258] 04/01 13:05:33 ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 1609
ORA-06512: at "SYS.DBMS_STATS", line 2119
ORA-06512: at "SYS.DBMS_STATS", line 7252
ORA-06512: at line 2
[258] 04/01 13:05:33 AbortScriptWithError()
[258] 04/01 13:05:33 AbortScript: Aborted ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 1609
ORA-06512: at "SYS.DBMS_STATS", line 2119
ORA-06512: at "SYS.DBMS_STATS", line 7252
ORA-06512: at line 2
(os errno 2) -
Cause
Statistics gathering is locked on this table.
-
Resolution
1. Unlock statistics gathering for the table:
exec dbms_stats.unlock_schema_stats('schema_owner');
exec dbms_stats.unlock_table_stats('table_owner','table_name');
2. Restart the reorg job