exec dbms_stats.lock_partition_stats

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. Received on Mon Mar 19 2007 - 10:14:04 CDT