Re: Looking for Partition Management tool(s) ?

Alex Sokol wrote:
>
> I was wondering if anyone came across any partition management tools
> available on the market from vendors such Quest, Precise, Embarcadero
> etc.?
> I'm looking for a can solution to roll forward my partitioned tables
> (and indexes of course) and drop old ones based on some criteria?
> We don't want to spend time developing this ourselves if we can
> purchase it.
> Any suggestions are appreciated.
>
> Thanks, Alex

It won't take you more than a couple of hours to develop...

The oldest partition always has partition id 1, and the newest one is easliy done by having a "dummy" partition which is less then maxvalue and then splitting that each day/week/month whatever.

You just wrap this in some PL/SQL and you're done...

Save your money...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."