Site icon Database Tutorials

ORA-20005 : object statistics are locked

 

If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table statistics.

When you run GATHER_TABLE_STATS, if it returns a result as follows you must unlock the statistics of the corresponding table.

 

Unlocking table statistics:

You can use the following command for this operation.

Exit mobile version