Re: Turn off Partitioning
Date: Wed, 18 Aug 2021 10:40:20 +0000
Message-ID: <AS8P192MB1397DF879912E8941DC8FA83F0FF9_at_AS8P192MB1397.EURP192.PROD.OUTLOOK.COM>
If there is a record of you using a chargeable feature you are risking a big back payment they are not kind to big or small if you can rebuild the dB.
Sent from another Galaxy.
chopt is a way to go as it is documented here: https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/chopt-tool.html#GUID-057E4EFC-74ED-43B3-B03B-C83C5A5D3C7F
The exact commands it uses are in $ORACLE_HOME/bin/chopt.ini.
Here is an example for partitioning (it is basically as Jonathan said with an additional command to make oracle):
[partitioning]
On Wed, 18 Aug 2021 at 09:34, Jonathan Lewis <jlewisoracle_at_gmail.com<mailto:jlewisoracle_at_gmail.com>> wrote:
It's a very long time since I did one, but the most secure way to deal with the problem is to create an Oracle executable that does not include the bits you don't want to pay for; but many years ago - for UNIX systems - I would use "make" to create new libraries and executables.
If you go to $ORACLE_HOME/rdbms/lib you will find a file called ins_rdbms.mk<http://ins_rdbms.mk>, this is the control file for make-ing Oracle. If you know where the log files are for the Oracle installation you will find there a file called something like "make.log". At the top of the file you'll find a line like:
/usr/bin/make -f ins_rdbms.mk<http://ins_rdbms.mk> clean rat_on part_on dm_on olap_on sdo_on rac_off dnfs_off ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1/
In this line "part_on" is one of the targets for make, and if you search ins_rdbms.mk<http://ins_rdbms.mk> you'll find the rule that applies for part_on; just below that there's a rule for part_off.
So you could execute make, changing the command line you find to use part_off instead of part_on (and changing the ORACLE_HOME/as appropriate. However, there are 3 things I would do first:
Regards
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Mikhail Velikikh <mvelikikh_at_gmail.com>
Sent: Wednesday, August 18, 2021 11:22:25 AM
To: Jonathan Lewis <jlewisoracle_at_gmail.com>
Cc: ORACLE-L <oracle-l_at_freelists.org>
Subject: Re: Turn off Partitioning
option=Oracle Partitioning
enable=run:/usr/bin/make -f /u01/app/oracle/product/21.3.0/dbhome_1/rdbms/lib/ins_rdbms.mk<http://ins_rdbms.mk> part_on ORACLE_HOME=/u01/app/oracle/product/21.3.0/dbhome_1;run:/usr/bin/make -f /u01/app/oracle/product/21.3.0/dbhome_1/rdbms/lib/ins_rdbms.mk<http://ins_rdbms.mk> ioracle ORACLE_HOME=/u01/app/oracle/product/21.3.0/dbhome_1
disable=run:/usr/bin/make -f /u01/app/oracle/product/21.3.0/dbhome_1/rdbms/lib/ins_rdbms.mk<http://ins_rdbms.mk> part_off ORACLE_HOME=/u01/app/oracle/product/21.3.0/dbhome_1;run:/usr/bin/make -f /u01/app/oracle/product/21.3.0/dbhome_1/rdbms/lib/ins_rdbms.mk<http://ins_rdbms.mk> ioracle ORACLE_HOME=/u01/app/oracle/product/21.3.0/dbhome_1
Jonathan Lewis
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 18 2021 - 12:40:20 CEST