Thanks all who replied. The purpose of this excercise is mainly #1 mentioned in Dennis
W.'s e-mail. Because of the size of this table, purging has been a challenge and we
want to keep only 2 years data in the table and periodically drop partitions to save
space.
Dennis
-Original
Dennis,
Remember that you need to have a catch all partition to keep the
data that does not fall into the date ranges you specify for the
partitions. Someone will always enter a future date into a record if
they are allowed.
When It comes time to drop the old partitions and add a new year there