-----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> Cheers, Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- //www.freelists.org/webpage/oracle-l