Archives of the TeradataForum

Message Posted: Fri, 20 May 2005 @ 19:50:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Kevin,

We do it the easy way. All of our new partitions are daily We add partitions twice a month each time adds 15 days. This technique can be done at any interval and for partitions of weekly and monthly. For dropping partitions, it is part of our monthly processes to remove the oldest month of data. Right now dropping the partitions is manual. We have plans to change it dynamically created ddl from table entries.

We have one situation where the table has partitions of different sizes. Right now moving data from daily to monthly and yearly partitions is done manually. When we have time this will be replaced with dynamically created ddl from table entries.

Also don't forget if you drop a partition but have NO RANGE the data will not be dropped, but moved to the NO RANGE partition. IN order for you to remove the data you also have to remove NO RANGE

     alter table dbname.tblname
     modify primary index (session_id)
     drop range between DATE '2004-08-01' AND DATE '2004-08-31'  EACH
     INTERVAL '1' DAY
     ,  NO RANGE OR UNKNOWN

Thanks,

Bob Diehl

	<Prev	Next>		<<First	<Prev	Next>	Last>>