ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at “SYS.DBMS_STATS”, line 23154
ORA-06512: at “SYS.DBMS_STATS”, line 23205…
To unlock lock statistics for a table execute the following procedure:
exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER', 'TABLE_NAME');
Read my post about how to prevent statistics from becoming locked after expdp impdp
Preventing locked Statistics after expdp impdp
No comments:
Post a Comment