Changing database options

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

chopt [enable|disable] {option}

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


Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

List RMAN backups size

AWR Generating & Setting