Re: Oracle Options

>
> Funnily enough even on a non partitioned installed installation there =
> are partitioned tables. Weird hey.
>

Those belong to Log Miner. Since Log Miner doesn't come with any extra licensing, it means you need Partitioning installed if you are going to use Log Miner. De-install Partitioning, break certain Log Miner functionality.

It's Oracle's lookout, and Oracle sales knows it. Oracle installs it by default; one has to "opt-out", and opting out causes problems. So, Oracle reduces problems by installing everything. By the by, occasionally it causes someone to think they can't live without something, so they buy. If they buy by mistake, it works out the same way.

Usage, not installation or deinstallation, determines what you pay. It's real easy to determine if you're actually using partitioning or not (i.e. "select count(*) from dba_tab_partitioning where table_owner not in ('SYS','SYSTEM','OUTLN')"). Likewise, its easy to determine if you are using any other separately-licensed option or not, regardless of install status...

--
http://www.freelists.org/webpage/oracle-l