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

ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.

1 Answers  


ORA-25453: invalid iterator: string

1 Answers  


RMAN-06508: MAXSETSIZE string kbytes should be greater than blocksize string bytes

1 Answers  


ORA-07561: szprv: $IDTOASC failure

1 Answers  


NNL-00521: Shows or sets the server's system query forwarding requirements

1 Answers  


ORA-16574: switchover disallowed when required databases are offline

1 Answers  


DRG-50801: failed to parse cursor

1 Answers  


ORA-00127: dispatcher string does not exist

1 Answers  


ORA-02145: missing STORAGE option

1 Answers   Oracle,


ORA-02837: Unable to unlink temporary file

1 Answers  


ORA-14167: only one subpartition may be moved

1 Answers  


ORA-09204: sfotf: error opening temporary file

1 Answers  


Categories