-
purging partitions
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).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|