RE: Oracle Options
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <DGoulet@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 May 2005 13:59:20 -0400
I try and not install all that crap to begin with. I only install the
components I need.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Goulet, Dick
Sent: Thursday, May 19, 2005 1:55 PM
To: mstahlke@xxxxxxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle Options
Who leaves the example schema's laying around a production db??=3D20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stahlke, Mark
Sent: Thursday, May 19, 2005 1:58 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle Options
=3D20
-----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
(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...
Interesting. What about the example schemas? Some of them use
partitioning.
Here is the output from a variation on Tim's query in a 9.2.0.4 database
that has the example schemas installed but partitioning is not used
otherwise.
SQL> select table_name, owner from dba_part_tables where owner not in
('SYS','SYSTEM','OUTLN');
TABLE_NAME OWNER
------------------------------ ------------------------------
COSTS SH
SALES SH
SQL>=3D20
Cheers,
Mark Stahlke
Oracle DuhBA
Denver Newspaper Agency
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
