Oracle | DBMS

Oracle DBMS_XDBT 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 Utilities for creating and managing conText indexes on the XDB repository.

AUTHID DEFINER

Constants

Name	Data Type	Value
Filtering Options
USE_NULL_FILTER	PLS_INTEGER	1
USE_INSO_FILTER	PLS_INTEGER	2
SKIP_DATA	PLS_INTEGER	3
Synchronization Options
SYNC_BY_PENDING_COUNT	PLS_INTEGER	1
SYNC_BY_TIME	PLS_INTEGER	2
SYNC_BY_PENDING_COUNT_AND_TIME	PLS_INTEGER	3
Configuration Settings
IndexName	VARCHAR2(32)	'XDB.XDB$CI'
IndexMemory	VARCHAR2(32)	'50M'

Dependencies

CTX_DDL	DBMS_LOB	PLITBLM
CTX_DOC	DBMS_SCHEDULER	UTL_GDK
CTX_OUTPUT	DBMS_STANDARD	XDB$RESOURCE
CTX_STOPWORDS	DBMS_XDB	XDB_DATASTORE_PROC
CTX_USER_PENDING	DBMS_XDBZ0	XMLTYPE
DBMS_ASSERT

Documented Yes

First Available Not Known

Security Model Owned by XDB with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsxdbz.sql

Subprograms

AUTOSYNCJOBBYCOUNT	CREATELEXERPREF	DROPPREFERENCES
AUTOSYNCJOBBYTIME	CREATEPREFERENCES	OPTIMIZEINDEX
CONFIGUREAUTOSYNC	CREATESECTIONGROUPPREF	SETSYNCTIMEOUT
CREATEDATASTOREPREF	CREATESTOPLISTPREF	SYNCINDEX
CREATEFILTERPREF	CREATESTORAGEPREF	XDB_DATASTORE_PROC
CREATEINDEX	CREATEWORDLISTPREF

AUTOSYNCJOBBYCOUNT

Procedure used by dbms_job to automatically sync up the context dbms_xdbt.autoSyncJobByCount( myIndexName IN VARCHAR2, myMaxPendingCount IN NUMBER, myIndexMemory IN VARCHAR2);

TBD

AUTOSYNCJOBBYTIME

Procedure used by dbms_job to automatically sync up the context index dbms_xdbt.autoSyncJobByTime( myIndexName IN VARCHAR2, myIndexMemory IN VARCHAR2);

TBD

CONFIGUREAUTOSYNC

Configures for automatic index synchronization dbms_xdbt.configureAutoSync;

exec xdb.dbms_xdbt.configureAutoSync;

      

      PL/SQL procedure successfully completed.

CREATEDATASTOREPREF

Creates the datastore preference dbms_xdbt.createDatastorePref;

exec xdb.dbms_xdbt.createDatastorePref;

      

      PL/SQL procedure successfully completed.

CREATEFILTERPREF

Creates the filter preference dbms_xdbt.createFilterPref;

exec xdb.dbms_xdbt.createFilterPref;

      

      PL/SQL procedure successfully completed.

CREATEINDEX

Creates the index dbms_xdbt.createIndex;

exec xdb.dbms_xdbt.createIndex;

      

      PL/SQL procedure successfully completed.

CREATELEXERPREF

Creates the lexer preference dbms_xdbt.createLexerPref;

exec xdb.dbms_xdbt.createLexerPref;

      

      PL/SQL procedure successfully completed.

CREATEPREFERENCES

Creates all preferences required by the context index on the XDB repository dbms_xdbt.createPreferences;

exec dbms_xdbt.createPreferences;

      

      PL/SQL procedure successfully completed.

CREATESECTIONGROUPPREF

Creates the section group dbms_xdbt.createSectionGroupPref;

exec xdb.dbms_xdbt.createSectionGroupPref;

CREATESTOPLISTPREF

Creates the stoplist dbms_xdbt.createStoplistPref;

exec xdb.dbms_xdbt.createStoplistPref;

      

      PL/SQL procedure successfully completed.

CREATESTORAGEPREF

Creates the storage preferences dbms_xdbt.createStoragePref;

exec xdb.dbms_xdbt.createStoragePref;

      

      PL/SQL procedure successfully completed.

CREATEWORDLISTPREF

Creates the wordlist dbms_xdbt.createWordlistPref;

exec xdb.dbms_xdbt.createWordlistPref;

      

      PL/SQL procedure successfully completed.

DROPPREFERENCES

Drops all preferences required by the context index dbms_xdbt.dropPreferences;

exec dbms_xdbt.dropPreferences;

      

      PL/SQL procedure successfully completed.

OPTIMIZEINDEX

Optimizes the index dbms_xdbt.optimizeIndex;

exec xdb.dbms_xdbt.optimizeIndex;

      

      PL/SQL procedure successfully completed.

SETSYNCTIMEOUT

Set a suggested time limit on the SYNC operation, in minutes dbms_xdbt.setSyncTimeout(timeout IN INTEGER := NULL);

exec xdb.dbms_xdbt.setSyncTimeout(10);

      

      PL/SQL procedure successfully completed.

SYNCINDEX

Synchronize the index dbms_xdbt.syncindex( myIndexName IN VARCHAR2 := Indexname, myIndexMemory IN VARCHAR2 := IndexMemory);

exec xdb.dbms_xdbt.syncindex('UWIdx', '500M');

XDB_DATASTORE_PROC

The user-datastore procedure. Oracle recommends that this not be called directly dbms_xdbt.xdb_datastore_proc( rid IN ROWID, outlob IN OUT NOCOPY CLOB);

TBD