On Apr 3, 10:04 am, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Apr 3, 4:47 pm, Chuck <skilover_nos..._at_bluebottle.com> wrote:
>
> > I've always found Oracle's licensing very confusing. Can someone please
> > clarify this for me? I have enterprise edition and want to partition
> > tables and indexes. Is it included or a separately licensed option?
> > Several documents on oracle.com mention partitioning as a separately
> > licensed option but they don't clarify if they are talking about
> > processor partitioning or table partitioning.
>
> > Thanks.
>
> It is included in a typical install, but it is not included in a
> typical license, ie it is a separate cost option.
> Note: if you have it installed, Oracle assumes you use it. If you
> don't use it, and you don't have a license, it is advisable to de-
> install, to avoid 'compliancy issues' (talking from experience).
> Obviously Oracle Partitioning is about *table* partitioning. As far as
> I know the 'Family' documents are not THAT unclear.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Interesting distinction that Oracle makes there. We have a very
vanilla installation, no partitioning on user tables. But a query of
dba_tab_partitions shows a bunch of SYS and SYSTEM tables that are
partitioned. Most appear to be associated with the OEM repository
tables and logminer tables. So it would appear that, for all
practical purposes, the partitioning option must be installed for
Oracle's own use, even if not for the customer's. The DB Feature
Usage report does make a distinction between user partition usage and
system partition usage.
Received on Tue Apr 03 2007 - 11:59:26 CDT
