Re: exec dbms_stats.lock_partition

From: EscVector <Junk_at_webthere.com>
Date: 20 Mar 2007 10:17:24 -0700
Message-ID: <1174411044.600333.213990@e65g2000hsc.googlegroups.com>

On Mar 19, 11:14 am, "EscVector" <J..._at_webthere.com> wrote:
> Where do you look to see that the partition statistics are locked?
> It is not in the select table_Name,STATTYPE_LOCKED from
> all_tab_statistics. The col remains blank for partitions.

the stat_locked column in the dba_tab_statistics table does not update for the partitions. this was reported as a bug. It should be fixed in patch 10.2.0.4.

The only work around is to capture the error using exceptions. The exception number for a locked table/partition is 20005. Received on Tue Mar 20 2007 - 12:17:24 CDT

Re: exec dbms_stats.lock_partition_stats