Re: Oracle's Partitioning Option.

On Fri, 23 Sep 2005 14:02:34 -0700, LineVoltageHalogen interested us by writing:

> Greetings All, can you tell me if Oracle's Partitioning Option is extra
> licencing for: 9i and/or 10g?

Self serve answers for this type of question are available at

http://docs.oracle.com

for Oracle9i DB, look in "Oracle9i Database New Features" manual, Ch 5 for OracleDB10g, look in "OracleŽ Database Licensing Information"

Short answer: Partitioning is an extra cost option that can be added only to Enterprise Edition.

That said, it's a fairly easy ROI analysis for this option. (Epecially if you have any warehouse requirements like "keep data for 'n' months" or your queries can take advantage of pruning. In my experience, the average payback is less than 8 months.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***