Its good line of thinking. You can merge partitions for older data , say each year in its yearly partition once the year is complete. Also for older data, you can make them read-only to save backup time On Tue, Jan 13, 2009 at 9:31 AM, April Wells <awells@xxxxxxxxxxxx> wrote: > Okay, I need to know if there exists a best practices document that I > can't find anywhere yet. > > > > I need to find a way to justify (or change my way of thinking). > > > > I have a data warehouse > > I have heavily partitioned data (partition by month) with each partition in > its own tablespace > > > > Reasoning > > I can make old data read only and speed up backups > > I can maintain at the tablespace level > > I can compres at the tablespace level > > > > I have "way too many" tablespaces (this has been suggested more than once > and has been posed as a problem with my thinking and my judgement) and there > is supposed to be some document somewhere that says no database needs more > than 50 tablespaces (odd though about that E-business suite thing for > years). > > > > Does anyone have any pointers to good partitioning best practices document > so I can re-educate myself or something. > > > > Thanks > > April > > > > > > April Wells > > SR Oracle DBA > > Netspend Corporation > > http://www.netspend.com > > > > ------------------------------ > > > > Confidentiality Notice! > This electronic transmission and any attached documents or other > writings are confidential and are for the sole use of the intended > recipient(s) identified above. This message may contain information > that is privileged, confidential or otherwise protected from > disclosure under applicable law. If the receiver of this > information is not the intended recipient, or the employee, or > agent responsible for delivering the information to the intended > recipient, you are hereby notified that any use, reading, > dissemination, distribution, copying or storage of this information > is strictly prohibited. If you have received this information in > error, please notify the sender by return email and delete the > electronic transmission, including all attachments from your > system. > >