Re: Oracle License for Optional Packs Question
Date: Fri, 17 Nov 2017 18:10:45 +0700
Message-ID: <CAP50yQ9WY9+EtCse9=fCO8s68JO=hkGkzVRPX+UtoiJsbbMN1g_at_mail.gmail.com>
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));
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/
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
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
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
> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 17 2017 - 12:10:45 CET