Home » RDBMS Server » Server Administration » Partitioned table: Package?
- Partitioned table: Package? [message #57803] Tue, 08 July 2003 11:03 Go to next message
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

Report message to a moderator

- Re: Partitioned table: Package? [message #57842 is a reply to message #57803] Thu, 10 July 2003 12:01 Go to previous message
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?

Report message to a moderator

Previous Topic: Server Tuning
Next Topic: Index Extents
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 04 22:41:15 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.