Statistics locked [message #330796] |
Tue, 01 July 2008 05:19  |
subbu_tce
Messages: 98 Registered: July 2007 Location: pune
|
Member |
|
|
Dear All,
Am trying to gather stats but am getting an error message as
" object statistics are locked (stattype = ALL) ".So am not bale to gather stats.What needs to be done?Kindly suggests...
|
|
|
Re: Statistics locked [message #330797 is a reply to message #330796] |
Tue, 01 July 2008 05:23   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Was it an ORA-38029?
ORA-38029: object statistics are locked
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.
|
|
|
|
|
Re: Statistics locked [message #330806 is a reply to message #330796] |
Tue, 01 July 2008 06:06  |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
> But why it has been locked ?
Good question, but wrong interviewee, as nobody in this forum knows more about your DB than you posted here.
Definitely you shall ask the database administrator (DBA) or people working on the schema you accessed.
|
|
|