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

NNL-01078: Access/Create File Error : string

1 Answers  


ORA-06549: PL/SQL: failed to dynamically open shared object (DLL): string

2 Answers  


RMAN-06415: file string cannot be proxy backed up

1 Answers  


DRG-11122: unsupported section group

1 Answers  


ORA-14062: one or more of table's partitions reside in a read-only tablespace

1 Answers  






ORA-14613: Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed

1 Answers  


NNO-00063: cannot construct domain checkpoint file name

1 Answers  


TNS-01057: Program name: string

1 Answers  


ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  


ORA-14120: incompletely specified partition bound for a DATE column

1 Answers  


PLS-00924: native compilation is not supported on this platform

1 Answers  


ORA-32842: value for property string cannot be altered

1 Answers  


Categories