Saturday, February 25, 2012

Changing database options

before oracle 11.2 we should have do this steps:
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all
from now this is simpler and shorter
cd %ORACLE_HOME%/bin
chopt disable dv
All options are written in the usage syntax:
usage:

chopt [enable|disable] {option}

options:
dm = Oracle Data Mining RDBMS Files
dv = Oracle Database Vault option
lbac = Oracle Label Security
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing

No comments: