Oracle | CTX

Oracle CTX_ADM Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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