Re: tough choices

datab0y_at_yahoo.com wrote:

> Actually, right now I've got several oracle & db2 systems that are
> using range partitioning.

DB2 using range partitioning? How? My assumption is that you are talking about different functionality using the same word. Because union-all views are not partitioning.

> So, actually I'm getting table partitioning for free from DB2 but have
> to pay for it from Oracle.

Word is the same ... functionality is completely different.

But even if what you said was correct ... How could use use union-all views to range partition by date and subpartition by hash? You are talking a work-around for a technology that doesn't exist in the product.

Nothing wrong with that but it just isn't the same thing.

> ok, but how much room do the oracle sales guys have to negotiate? Can
> you pit resellers against one another? etc, etc.

Absolutely. They have huge flexibility. Like used car salesmen.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)