ask for good suggestion on partition method
Hi,All:
We need to preserve the most current 90 days data to be analyzed(by day, month, week and date range). The data of a day is very large and increased everyday. One way I thought out is to do the parttion based on the days from year start,that's, 365 days, 365 partitions. Is there more good suggestion to do partition more effectively? Thanks a lot.
Subject
Views
Written By
Posted
ask for good suggestion on partition method
3523
January 13, 2008 02:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.