DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007


    Hi -

    I am trying to determine if it is possible to run the DBMS_STATS_FUNCS.SUMMARY procedure against just one partition of a partitioned table. I have a large, range partitioned table in an Oracle 10g database. Each month I load ~ 1 billion new rows into a new partition in that table . I want to find a way to see what has changed with the data, in order to give feedback to my data provider on the quality of the data. I generate optimizer stats including column histograms, immediately after loading, which gives some insight into the distribution of the data in each column in the table. However, if I could run this procedure against the newly loaded data, I could get the mean, variance, std deviation, etc. that would be even better.

    I have tried the following:

    dbms_stat_funcs.summary('SCOTT', 'PARENT_TAB partition(part_2007)', 'ID', sig, s);

    dbms_stat_funcs.summary('SCOTT', 'PARENT_TAB.PART_2007', 'ID', sig, s);

    These attempts give me ORA-44003 errors.

    So far I have only been able to use this procedure against an entire table.

    Anyone had success with this?

  2. #2
    Join Date
    Jan 2001

    Have you looked at doing this using straight sql rather then using the supplied function.

    I am afraid you cannot do this with the supplied function at a partition level.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.