purging partitions

[pascal01]

Hi,
I need to write a script that will automatically remove the oldest partition and insert a new partitions. (ie remove the oldest month, then add new month's data).
Could somebody advise where I can find a sample script that will do this task?
I looked in metalink and found nothing usefull.
Thanks for your support,

[mike9]

where is exactly your problem?

You simply have to add and drop a partition. The following documentation explains how you can do it:

http://download.oracle.com/docs/cd/B...1.htm#i2131048
http://download.oracle.com/docs/cd/B...1.htm#i2131064

[pascal01]

Hi, I do not have a problem with the syntax or concept.
I am looking for a sample script (written in pl/sql ?) that I can use as a model to achieve this. Do you know of a website where i can find scripts that can do this?
Regards,
Pascal

[mike9]

I'm sure that if you read the doc you should be able to do it by your own (in less then an hour).