Printable View
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,
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
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
I'm sure that if you read the doc you should be able to do it by your own (in less then an hour).