Oracle8i interMedia Text Migration
Release 8.1.5

A67845-01

Library

Product

Contents

Index

Prev Next

3
Administration

This chapter describes the administration concepts that have changed from 2.X to 8.1.5. The following topics are covered:

Servers

Pre-8.1.5

In pre-8.1.5, the ConText server, ctxsrv, has five personalities, R Q D M and L. A single server can have one or more personalities. A combination of personalities is called a mask. With personality masks, you can assign to a server different functions, such as query processing, DDL processing, or linguistic processing.

8.1.5

In 8.1.5, the ctxsrv executable is not required for indexing or querying. Indexing and querying are performed with standard SQL. You run the server only for background DML processing. No server is needed for performing batch DML, which you do by synchronizing the index with ALTER INDEX.

The ctxsrv executable is also not required for producing document services output, such as theme summaries and Gists. You obtain document services output synchronously with procedures the CTX_DOC package.

When you start ctxsrv, the only personality you can specify is M, which is the default.

See Also:

For more information about ctxsrv, ALTER INDEX and the CTX_DOC package, see the Oracle8i interMedia Text Reference.  

Viewing the Status of Servers

interMedia Text 8.1.5 does not support the ctxctl command that is used in pre-8.1.5 to view the status of ConText servers.

In 8.1.5 to view the status of a server, you can use the CTX_SERVERS view. You can also use the Oracle8i interMedia Text Manager, which is a Java application available with the Oracle Enterprise Manager.


Note:

The Oracle8i Enterprise Manager is shipped on a separate CD from Oracle8i interMedia Text.  


Roles and Users

pre-8.1.5

In pre-8.1.5, a ConText user can be assigned one of three pre-defined ConText roles

8.1.5

In 8.1.5, the CTXADMIN and CTXUSER roles are obsolete. A Text user can only be assigned the CTXSYS or CTXAPP roles.

CTXSYS Role

The CTXSYS role enables users to do the following

CTXAPP Role

The CTXAPP role enables users to do the following:

Granting Roles and Privileges to Users

In pre-8.1.5, the system uses the standard SQL model for granting roles to users. This model has not changed for interMedia Text 8.1.5. To grant a Text role to a user, you use SQL GRANT command.

In addition, to allow application developers to call procedures in the interMedia Text PL/SQL packages, you must explicitly grant to each user EXECUTE privileges for the interMedia Text package.

Document Loading

pre-8.1.5

You use the ctxload executable to load documents into LONG or LONG RAW text columns. You also use it to import thesauri.

8.1

ctxload

In 8.1.5, ctxload still supports the loading of LONGs and LONG RAWs as well as importing thesauri.


Suggestion:

If your pre-8.1.5 application uses LONG or LONG RAW to store your documents, Oracle recommends that you migrate these columns to LOBs. To do so, you can use the SQL operator TO_LOB.

For more information about migrating your LONGs and LONG RAWs to LOBs, see Oracle8i Migration.

For more information about loading LONGs with ctxload, see Oracle8i interMedia Text Reference.  


SQL*Loader

In 8.1.5, you can store documents in the columns types of CHAR, CLOB, BLOB, BFILE, or VARCHAR2. To load documents to any of these data types, you can use SQL*Loader.

See Also:

For an example of using SQL*Loader, see Oracle8i interMedia Text Reference.  

Queues and Pipes

Pre-8.1.5

In pre-8.1.5, ConText uses the text request queue to process text operations. The text request queue is made up of a query pipe, a DDL pipe, a DML queue, and a services queue.

8.1.5

In 8.1.5, text indexing and querying are performed with standard SQL. As such, all queues and pipes except the DML queue are obsolete.

The DML queue stores requests for index updates and is populated by Oracle.

Pending DML requests can be viewed with CTX_PENDING and CTX_USER_PENDING views.

DML errors can be viewed with the CTX_INDEX_ERRORS or CTX_USER_INDEX_ERRORS view.

Enabling One-Step Queries

Pre-8.1.5

In pre-8.1.5, you enable one-step queries by setting the text_enable variable to TRUE in the initsid.ora file.

8.1.5

In 8.1.5, you use standard SQL to issue a Text query. After installing interMedia Text 8.1.5, no extra setup steps are necessary. You can issue Text queries once you have created a valid Text index.

See Also:

For more information about creating Text indexes, see Chapter 5, "Indexing".  

Administration Tool

Pre-8.1.5

In pre-8.1.5, you can use the GUI Administration Tool to create indexes, start servers etc. This tool is available with the ConText Workbench.

8.1.5

The interMedia Text 8.1.5, the administration tool has been replaced with the Oracle8i interMedia Text Manager. This tool 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 start, monitor and shutdown ctxsrv DML servers.

See Also:

for more information about the Oracle8i interMedia Text Manager, see the online help shipped with this tool.  




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index