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

IMG-00840: image structure allocation failed

1 Answers  


ORA-29323: ALTER DATABASE SET COMPATIBILITY command not supported by string

1 Answers  


ORA-15076: Emulating I/O errors on the OSM disk

1 Answers  


ORA-26520: internal memory failure

1 Answers  


TNS-12159: TNS:trace file not writeable

1 Answers  






ORA-09851: soacon: Archmon unable to lock named pipe.

1 Answers  


IMP-00084: attempt to mix incremental import with user or table import

1 Answers  


ORA-19655: cannot switch to incarnation with different resetlogs data

1 Answers  


ORA-00082: memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  


SQL*Loader-00125: specified value for readsize(number) less than max_record_size(number)

1 Answers  


ORA-25457: evaluation function string returns failure

1 Answers  


Categories