Oracle CTX_ADM
Version 21c

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 No
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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
CTX_ANL
CTX_CATSEARCH
CTX_CLS
CTX_CONTAINS
CTX_DDL
CTX_ENTITY
CTX_MATCHES
CTX_OUTPUT
CTX_REPORT
CTX_TREE
CTX_ULEXER
CTX_XPCONTAINS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx