Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

incremental statistics in 10g

chijarJan 9 2012 — edited Jan 11 2012
dear all
facts:
- oracle ent 10.1.0.5
- aix 5.3
- datawarehouse environment
- a lot of partitioned tables

I want to implement an incremental statistics in order to apply in partitions recently loaded. not in all table. Do you have a script or plsql block in order to do that?

I know that in 11g this method exists by im looking for 10.1.0.5

thanks for your answers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2012
Added on Jan 9 2012
8 comments
392 views