Monday, June 12, 2017

Find Table Locked or not and How to Unlock Table

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

No comments:

Post a Comment