• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
When I execute UTIL A/9, I get the following error message:

error delete:

ANALYZE TABLE XXX50.Z353 DELETE STATISTICS
*
ERROR at line 1:
ORA-38029: object statistics are locked

Resolution:
You need to delete the statistics manually. First log in as ALEPH_ADMIN by typing:

sqlplus $ALEPH_ADMIN

Then execute the following command (replace with the relevant library and table):

exec dbms_stats.unlock_table_stats('XXX50','Z353');

• Article last edited: 10/8/2013