Re: Partitioning Best Practices
From: <mccmx_at_hotmail.com>
Date: Wed, 9 Jul 2008 17:17:06 -0700 (PDT)
Message-ID: <af4a19ef-921d-44cc-b4ce-a98a4e95cfe2@l64g2000hse.googlegroups.com>
Date: Wed, 9 Jul 2008 17:17:06 -0700 (PDT)
Message-ID: <af4a19ef-921d-44cc-b4ce-a98a4e95cfe2@l64g2000hse.googlegroups.com>
> 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