Partitioned table: Package? [message #57803] |
Tue, 08 July 2003 11:03 |
Joe
Messages: 138 Registered: November 1999
|
Senior Member |
|
|
I am looking for a sample script to create a job that will create a daily partition for a table in my database schema. If anyone has one that I can look at I would greatly appreciate it. I have a table with 90 million records that I want to partition by day and roll off (drop) a partition after 14 or so days. Currently, I have a delete job, but obviously my high water mark is too high, so I am attempting to find a better solution.
Thank you
joe
|
|
|
Re: Partitioned table: Package? [message #57842 is a reply to message #57803] |
Thu, 10 July 2003 12:01 |
Angelo
Messages: 16 Registered: November 2001
|
Junior Member |
|
|
When you drop a partition, it's gone. So I dont realy understand where you have your high wather mark problem.
So to be able to better understand your problem could you answer the follwong questions:
What is exactly the problem with your high water mark?
9M rows over how many days?
Are you a only inserting or also updaaating & deleting rows?
What exactly do you expect from that package?
|
|
|