To check table has been locked or not:
select owner, table_name, stattype_locked
from dba_tab_statistics
where stattype_locked is not null
Unlock the particular table:
exec dbms_stats.unlock_table_stats('APPLSYS','FND_CP_GSM_IPC_AQTBL');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_IN');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_OUT');
select owner, table_name, stattype_locked
from dba_tab_statistics
where stattype_locked is not null
Unlock the particular table:
exec dbms_stats.unlock_table_stats('APPLSYS','FND_CP_GSM_IPC_AQTBL');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_IN');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_OUT');
No comments:
Post a Comment