how to enable or disable oracle database features?


chopt tool a command-line utility is used for enabling or disabling a particular database feature for an Oracle home.

Location:- ORACLE_HOME\bin directory

Syntax:- chopt [ enable | disable] <option>

options:
dm = Oracle Data Mining RDBMS Files
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing
ode_net = Oracle Database Extensions for .NET

Example of running the chopt tool:-

chopt enable dm
chopt disable dm

Sample output:-

No comments :
Write comments