Error:
[2014-11-04T18:37:57.138-05:00]
[RCU] [ERROR] [upgrade.RCU.jdbcEngine] SQLException: ORA-20005: object
statistics are locked (stattype = ALL)[[
ORA-06512: at
"SYS.DBMS_STATS", line 3683
ORA-06512: at
"SYS.DBMS_STATS", line 4516
ORA-06512: at
"SYS.DBMS_STATS", line 11564
ORA-06512: at line 10
]]
[2014-11-04T18:37:57.138-05:00]
[RCU] [ERROR] [upgrade.RCU.jdbcEngine] [[
java.sql.SQLException: ORA-20005:
object statistics are locked (stattype = ALL)
ORA-06512: at
"SYS.DBMS_STATS", line 3683
ORA-06512: at "SYS.DBMS_STATS",
line 4516
ORA-06512: at
"SYS.DBMS_STATS", line 11564
ORA-06512: at line 10
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
Solution:
exec dbms_stats.unlock_schema_stats('QA_MDS');
exec dbms_stats.unlock_schema_stats('SYS');
exec dbms_stats.unlock_table_stats('QA_MDS','MDS_TXN_LOCKS');
commit;
No comments:
Post a Comment