| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Utilities for creating and managing creating and managing conText indexes in an 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' |
|
| Data Types |
TYPE varcharset IS TABLE OF VARCHAR2(100); |
| 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 |
| Pragmas |
PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE) |
| Security Model |
Owned by XDB with EXECUTE granted to the DBA role |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsxdbtint.sql |
| Subprograms |
|
| |
| 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
(new 23ai overload)
 |
Configures for automatic index synchronization
Overload 1 |
dbms_xdbt.configureAutoSync; |
exec xdb.dbms_xdbt.configureAutoSync;
PL/SQL procedure successfully completed. |
| Overload 2 |
dbms_xdbt.configureAutoSync(
policy IN PLS_INTEGER,
maxCount IN PLS_INTEGER,
sync_interval IN PLS_INTEGER,
checkInterval IN PLS_INTEGER); |
| TBD |
| |
| 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
(new 23ai overload)
|
| Creates the section group |
dbms_xdbt.createSectionGroupPref; |
exec xdb.dbms_xdbt.createSectionGroupPref; |
| Overload 2 |
dbms_xdbt.configureSectionGroupPref(secGroup
IN VARCHAR2); |
exec xdb.dbms_xdbt.createSetionGroupPref('UWSectGrp'); |
| |
| 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 |