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@xxxxxxxxx>
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@xxxxxxxxxxxxxxx>
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
| @zztat_oracle
