2009년 10월 14일 수요일

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}');

from : http://erkanorclog.blogspot.com/2008/09/ora-38029-object-statistics-are-locked.html