ORA-38029 : object statistics are locked Recently This error comes when analyzing tables in oracle. Basic issue in this error is when you import table without data i.e structure/schema only, oracle will lock table statistics.
You can view all the locked tables in schema by executing following query:
select table_name, stattype_locked
from dba_tab_statistics
where owner = ‘MBS’ and stattype_locked is...
by Nauman at November 5th, 2009 at 06:11 am 
Subscribe to RSS