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

TNS-00017: INTCTL: error while performing NS receive command

1 Answers  


ORA-12084: must use ALTER MATERIALIZED VIEW to alter "string"."string"

1 Answers  


ORA-06304: IPA: Message receive error

1 Answers  


ORA-15047: ASM file name 'string' is not in multiple-file creation form

1 Answers  


ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area

1 Answers  






ORA-12679: Native services disabled by other process but required

1 Answers  


TNS-00070: INTCTL usage: [intctl] <command> <process_name> [argument]

1 Answers  


ORA-27080: too many files open

1 Answers  


PLS-00650: invalid type for PARTITION/CLUSTER/ORDER BY clause

1 Answers  


ORA-31664: unable to construct unique job name when defaulted

1 Answers  


PLS-01463: STDDEV is not a standard set function

1 Answers  


ORA-13705: There was a instance shutdown/startup between the snapshots in the range [string, string].

1 Answers  


Categories