RE: Oracle Options

  • From: "Stahlke, Mark" <mstahlke@xxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 19 May 2005 11:58:10 -0600


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Tim Gorman
Sent: Thursday, May 19, 2005 11:32 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle Options

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

Interesting. What about the example schemas? Some of them use partitioning.
Here is the output from a variation on Tim's query in a database
that has the example schemas installed but partitioning is not used

SQL> select table_name, owner from dba_part_tables where owner not in

TABLE_NAME                     OWNER
------------------------------ ------------------------------
COSTS                          SH
SALES                          SH


Mark Stahlke
Oracle DuhBA
Denver Newspaper Agency

Other related posts: