Re: dynamically add partition

From: o <new2unix_at_gmail.com>
Date: 14 Feb 2006 03:06:30 -0800
Message-ID: <1139915190.907954.135140@g43g2000cwa.googlegroups.com>

i have a similar problem

my first partition name is

PARTITION HWCDR450_20050917 VALUES LESS THAN (TO_DATE(' 2005-09-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) now i want to add partition automatically everyday which will be smaller than sysdate that is (sysdate -1)

what will be tha code for this?

thanx

o schrieb:

> if I have a table and partitioned based it on date. Then how can I
> extend the partitions
> dynamically ! That is I want to generate a partition everyday !
> As the data is very large ! So help me out !
Received on Tue Feb 14 2006 - 05:06:30 CST