Thursday, November 6, 2008

ORA-38029: object statistics are locked

While trying to analyze a table if the statistics are locked then this eror will occur
unlock the table stats

exec dbms_stats.unlock_table_stats('{owner}','{table name}');

also  we  can  lock  table statistics  like
exec dbms_stats.lock_table_stats('{owner}','{table name}');

No comments: