Re: Partitioning -- good? cost?

My Oracle rep. told me formally that the Object Option and Partitioning Option
if NOT free, and are costed per-user like other Options.

Really bad!

John Gassman wrote in message <353feb0e.0_at_athena.netset.com>...
>I couldn't live without them! I run 8.0.3 on Windows NT and I have a huge
>table (> 40 GB) that I need to contain 'rolling' data. Previously I had to
>delete out old records (this took FOREVER) or periodically truncate the
>table and start over. With partitions, I can add a new partition for a new
>day and drop the oldest day's partition - takes about a minute. Plus,
>paritioning in Oracle8 is automatic - you don't have to figure out which
>partition the data belongs in. Paritioning also helps speed up access if
>partitions are divided by the same criteria as your queries - eg: date -
>Oracle knows it only has to look in certain partitions and can skip the
>rest.
>
>As far as I know, partitioning is included with Oracle8 at no additional
>cost.
>
>John Gassman
>LCI International
>
>Primal Systems wrote in message <353d0ca5.15650940_at_news1.occa.home.net>...
>>Are people using the table partitioning feature? Care to share your
>>experience?
>>
>>Is it only available at extra cost, above and beyond Enterprise
>>license?
>>
>>Joshua Stern
>>JRStern_at_primalsys.com
>>
>
>
Received on Sun Apr 26 1998 - 04:44:02 CDT