General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
Purpose
Context Administration DR system ADMinistration services
AUTHID
DEFINER
Dependencies
CTX_DOC
DRIG
DRIXMD
DBMS_ASSERT
DRILIST
DRUE
DBMS_STANDARD
DRIOPT
DRVDISP
DR$PARAMETER
DRIPREF
DRVUTL
DR$SECTION_GROUP
DRIREC
DRVXMD
DR$STOPLIST
DRIUTL
DR_DEF
DRIDISP
Documented
Yes: Packages and Types Reference
Exceptions
Error Code
Reason
DRG-10502
index <schema_name.index_name> does not exist
First Available
Not known
Security Model
Owned by CTXSYS with no privileges granted
Source
{ORACLE_HOME}/ctx/admin/dr0adm.pkh
Subprograms
DROP_USER_OBJECTS
Drops all of the text objects (preferences, etc.) for the given user
ctx_adm.drop_user_objects(user_name IN VARCHAR2);
exec ctxsys.ctx_adm.drop_user_objects ('C##UWCLASS');
PL/SQL procedure successfully completed.
MARK_FAILED
Mark the index status from INPROGRESS to FAILURE so that
alter index can run
ctx_adm.mark_failed(
owner_name IN VARCHAR2,
index_name IN VARCHAR2);
PRAGMA SUPPLEMENTAL_LOG_DATA(mark_failed, AUTO);
exec ctxsys.ctx_adm.mark_failed ('C##SAFEDBA', 'IXD_DOCHDR');
RECOVER
Recover data dictionary
ctx_adm.recover;
PRAGMA SUPPLEMENTAL_LOG_DATA(recover, AUTO);
-- example from $ORACLE_HOME/rdbms/admin/wkremov.sql
exec ctxsys.ctx_adm.recover ;
PL/SQL procedure successfully completed.
RESET_AUTO_OPTIMIZE_STATUS
Resets the autoopt_status table
ctx_adm.reset_auto_optimize_status;
exec ctxsys.ctx_adm.reset_auto_optimize_status ;
PL/SQL procedure successfully completed.
SET_PARAMETER
Set a system parameter
ctx_adm.set_parameter(
param_name IN VARCHAR2,
param_value IN VARCHAR2);
PRAGMA SUPPLEMENTAL_LOG_DATA(set_parameter, AUTO);
-- examples from $ORACLE_HOME/rdbms/admin/dbmsxdbt_int.sql
exec ctxsys.ctx_adm.set_parameter ('MAX_INDEX_MEMORY', '128M');
exec ctxsys.ctx_adm.set_parameter ('LOG_DIRECTORY', '/tmp');
SHUTDOWN
This call is obsolete. It exists simply to avoid invalidating obsolete customer code which may call it
ctx_adm.shutdown(
name IN VARCHAR2 DEFAULT 'ALL',
sdmode IN NUMBER DEFAULT NULL);
Obsolete
STOP_OPTIMIZE
Stop an optimize for an index / partition
ctx_adm.stop_optimize(
owner_name IN VARCHAR2,
index_name IN VARCHAR2,
partition_name IN VARCHAR2 DEFAULT NULL);
exec ctxsys.ctx_adm.stop_optimize ('C##UWCLASS', 'IXD_DOCHDR');
PL/SQL procedure successfully completed.
TEST_EXTPROC
Test extproc invocation
ctx_adm.test_extproc;
exec ctxsys.ctx_adm.test_extproc ;
PL/SQL procedure successfully completed.