ORA-20005的解决方法

today i import data from one db to anohter db

meet thsese errors

1:ora-20005 /imp-00003

and then i find the i cannot do anylyase table .

i suspect my may was wrong .now i found the solution

1:use below commnad to find which table was lock（查找被锁的表）

select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null and
owner=’TIBCOEAI’ ;

select ‘exec dbms_stats.unlock_table_stats(”WMS”,”’||table_name||”’); ’ from sys.dba_tab_statistics
where stattype_locked is not null and owner=’WMS’ ;

2: use this commnad to unlock them（被锁的表解锁）

exec dbms_stats.unlock_table_stats(”WMS”,”’||table_name||”’);

3 can do analyze table

参考地址