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:
Post a Comment
Note: Only a member of this blog may post a comment.