|Oracle Text Application Developer's Guide
Part Number A96517-01
This chapter describes Oracle Text administration.The following topics are covered:
While any user can create an Oracle Text index and issue a
CONTAINS query, Oracle Text provides the
CTXSYS user for administration and the
CTXAPP role for application developers.
CTXSYS user is created at install time. You administer Oracle Text users as this user.
CTXSYS can do the following:
CTX_ADMPL/SQL package to set system-parameters
CTXAPP role is a system-defined role that enables users to do the following:
Any user can create an Oracle Text index and issue a Text query. The
CTXAPP role allows users create preferences and use the PL/SQL packages.
The system uses the standard
SQL model for granting roles to users. To grant a Text role to a user, use the
In addition, to allow application developers to call procedures in the Oracle Text PL/SQL packages, you must explicitly grant to each user
EXECUTE privileges for the Oracle Text package.
When there are inserts, updates, or deletes to documents in your base table, the DML queue stores the requests for documents waiting to be indexed. When you synchronize the index with
SYNC_INDEX, requests are removed from this queue.
Pending DML requests can be queried with the
DML errors can be queried with the
Oracle Text Reference for more information about these views.
CTX_OUTPUT PL/SQL package to log indexing and document service requests.
Oracle Text Reference for more information about this package.
You index documents and issue queries with standard SQL. No server is needed for performing batch DML. You can synchronize the
CONTEXT index with the
For more information about indexing and index synchronization, see Chapter 2, "Indexing".
The Oracle Text Manager is a Java application integrated with the Oracle Enterprise Manager, which is available on a separate CD.
The Text Manager enables administrators to create preferences, stoplists, sections, and indexes. This tool also enables administrators to perform DML.
for more information about the Oracle Text Manager, see the online help shipped with this tool.