| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Context Administration DR system ADMinistration services |
| AUTHID |
DEFINER |
| Dependencies |
| CTX_DOC |
DRIG |
DRUE |
| DBMS_ASSERT |
DRILIST |
DRVDISP |
| DBMS_STANDARD |
DRIPREF |
DRVUTL |
| DR$PARAMETER |
DRIREC |
DRVXMD |
| DR$SECTION_GROUP |
DRIUTL |
DR_DEF |
| DR$STOPLIST |
DRIXMD |
|
|
| 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); |
exec ctxsys.ctx_adm.mark_failed('C##SAFEDBA', 'IXD_DOCHDR'); |
| |
| RECOVER |
| Recover data dictionary |
ctx_adm.recover; |
-- 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); |
-- examples from $ORACLE_HOME/rdbms/admin/dbmsxdbt_int.sql
exec ctxsys.ctx_adm.set_parameter('MAX_INDEX_MEMORY', '128M');
PL/SQL procedure successfully completed.
exec ctxsys.ctx_adm.set_parameter('LOG_DIRECTORY', '/tmp');
PL/SQL procedure successfully completed. |