Hi Greg, Thanks for your response.
Currently, such records are left in the overflow partition and its responsibility of user to insert them into partitioned-table which will then re-direct those to appropriate partitions. Regards, -- Kedar. On Tue, Apr 21, 2009 at 5:29 PM, Greg Stark <st...@enterprisedb.com> wrote: > On Tue, Apr 21, 2009 at 12:50 PM, Kedar Potdar <kedar.pot...@gmail.com> > wrote: > > I want to seek general opinion from the community on preferences between > > user-friendly ‘Oracle’ syntax, and a more generic syntax that allows > ‘gaps’ > > in partition ranges? > > > What happens to records in the overflow table when you add a new > partition whose range covers their values? > > -- > greg >