ORA-38029: object statistics are locked



ORA-38029: object statistics are locked..

Answer / guest

Cause: An attept was made to modify optimizer statistics of
the object.

Action: Unlock statistics with the
DBMS_STATS.UNLOCK_TABLE_STATS procedure on base table(s).
Retry the operation if it is okay to update statistics.

Please add more information about this Error

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

DRG-51312: DML lock internal error string

1 Answers  


ORA-00111: invalid attribute string

1 Answers  


UDI-00003: all allowable logon attempts failed

1 Answers  


NID-00122: Database should have no offline immediate datafiles

1 Answers  


ORA-01564: rollback segment is not PUBLIC

1 Answers  






ORA-01904: DATAFILE keyword expected

1 Answers  


DRG-11876: When Your Are Connected, You Can Log In

1 Answers  


ORA-31471: invalid OBJECT_ID value

1 Answers  


NID-00602: Could not allocate number bytes for "string"

1 Answers  


PCC-02081: CMD-LINE: Unterminated option value list or value list was truncated.

1 Answers  


RMAN-03030: echo set off

1 Answers  


ORA-01037: maximum cursor memory exceeded

1 Answers  


Categories