Oracle | CTX

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 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	RESET_AUTO_OPTIMIZE_STATUS	STOP_OPTIMIZE
MARK_FAILED	SET_PARAMETER	TEST_EXTPROC
RECOVER	SHUTDOWN

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.

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx