ERROR at line 1:
ORA-38029: object statistics are locked
ORA-06512: at "SYS.DBMS_DDL", line 257
ORA-06512: at "SYS.DBMS_UTILITY", line 488
ORA-06512: at line 1
ORA-38029: object statistics are locked
If this error occurs while trying to analyze a table then run following to unlock the statistics:
exec DBMS_STATS.UNLOCK_TABLE_STATS('{owner}','{table name}');
You can see list of all locked tables by running following query:
select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null and owner not in ('SYS','SYSTEM');
another solution
select 'exec DBMS_STATS.UNLOCK_TABLE_STATS('''||owner||''','''||table_name||''');' from dba_tab_statistics where stattype_locked is not null and owner not in ('SYS','SYSTEM');
