Gurelei Absolutely you can partition by week. The creative DBA is a top DBA! You keep mentioning aggregation. Have you considered Materialized Views?
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, March 20, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Hi all: An application I'm supporting needs weekly aggregates. Nothing wrong with that except I'm thinking of how to partition that aggregate table. The requirement is to keep 3 year history of data. I have been partitioning other aggregate tables (monthly etc) by month. This makes it easy to drop old partitions AND Oracle can use the partitions to reduce the size of the data for some queries. I'd like to keep the montly partitioning in for the uniformity reasons, but weeks do not lay over months, a week can span two months and therefore the usefulness of partitions for some of the reports will be reduced. I'm wondering how do others approach this. Do people partition weekly aggregates by week instead of months? ANy other thoughts? thanks Gene __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
