Re: Oracle License for Optional Packs Question

How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1) is the relevant note.

On Fri, Nov 17, 2017 at 11:10 AM, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

> Interesting! I did not know about that, and it even seems to work:
>
> SQL> create table foo (x int ) partition by range (x) (partition p1 values
> less than (100));
> create table foo (x int ) partition by range (x) (partition p1 values less
> than (100))
> *
> ERROR at line 1:
> ORA-00439: feature not enabled: Partitioning
>
> However, I'd be careful doing this on production, since it will relink
> your Oracle binary:
>
> -bash-3.2$ chopt disable partitioning
>
> Writing to /u00/app/oracle/product/11.2.0.4/install/disable_
> partitioning.log...
> /usr/bin/make -f /u00/app/oracle/product/11.2.0.4/rdbms/lib/ins_rdbms.mk
> part_off ORACLE_HOME=/u00/app/oracle/product/11.2.0.4
> /usr/bin/make -f /u00/app/oracle/product/11.2.0.4/rdbms/lib/ins_rdbms.mk
> ioracle ORACLE_HOME=/u00/app/oracle/product/11.2.0.4
>
>
>
>
> On Fri, Nov 17, 2017 at 5:53 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk>
> wrote:
>
>> Look at the chopt utility supplied eith your Oracle version. Run it
>> without parameters snd it will tell you what xan and cannot be
>> disabled/enabled.
>>
>> It fiffers between releases.
>>
>> Cheers,
>> Norm.
>> --
>> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
>
>
>
> --
> //
> zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
> Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat
> | _at_zztat_oracle
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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