Re: Partitioning Best Practices

From: <>
Date: Wed, 9 Jul 2008 17:17:06 -0700 (PDT)
Message-ID: <>

> Using a MAXVALUE partition makes it impossible to insert a different
> partition that logically follows the one preceding it: Thus you are
> in a dead-end situation. The best solution is no MAXVALUE and to use
> a regularly scheduled job to add partitions on a regular basis. Make
> sure the job checks for skipped partitions before adding the next one.

Are you sure...? What about SPLIT PARTITION which will add a new partition in between existing partitions:

alter table <TABNAME> split partition <MAXVALUE> at <DATE> into <NEWPART> , <MAXVALUE>; Received on Wed Jul 09 2008 - 19:17:06 CDT

Original text of this message