Oracle DBMS_XDBT
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 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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDBZ
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx