Oracle ConText Option QuickStart, Release 2.3 Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents



Go to previous file in sequence

Implementing ConText


This chapter provides information for quickly and easily implementing ConText.

The chapter covers the following topics:

Pre-implementation Checklist

This QuickStart manual assumes that Oracle7 is installed and running. In addition, the manual assumes that basic Oracle implementation tasks have been performed.

Before you proceed to the ConText implementation questions, verify the following:

Oracle7 installed and running
Tablespaces created
Oracle users created and granted necessary database roles


Note:

The Oracle user who performs the QuickStart implementation must be granted the CONNECT and RESOURCE roles.

 

See Also:

Oracle7 Server SQL Reference, Oracle7 installation documentation specific to your operating system

 

Implementation Questions

This section provides a list of ConText implementation questions that you need to answer before you can begin the QuickStart tasks:

1. "Have you created tables to store your text?"

2. "Is text loaded into your tables?"

3. "Is ConText installed?"

4. "Is the ConText initialization parameter enabled?"

5. "Is CTXAPP granted to users who own tables?"

The answers you provide depend on whether text is already stored in Oracle7 or you are storing text for the first time.


Note:

This QuickStart manual presents an example Oracle user named ctxdev and an example text table named docs; however, the ctxdev user and the docs table are not provided by ConText. The QuickStart examples assume that docs (or its equivalent) is in the database schema for ctxdev (or its equivalent).

 

1. Have you created tables to store your text?

YES:

Proceed to Question 2 >

NO:

You need to create one or more tables for storing your text. Each table used to store text must have at least the following columns:

To create tables, log in to SQL*Plus as the Oracle user who will own the tables and use the CREATE TABLE command.

See Also:

Oracle7 Server SQL Reference

 

2. Is text loaded into your tables?

YES:

Proceed to Question 3 >

NO:

You need to load documents (text) into your table(s). ConText supports three types of storage for documents:

Storage Type   Description  

Internal

 

A document is represented as either a single row or multiple rows in a database table. The text of the document is stored in one of the table columns. Each row is indexed by ConText as a separate entity.

 

Internal master/detail

 

A document is represented as multiple rows in a database table. The text of the document is stored in one of the table columns. The collection of rows for the document are indexed by ConText as a single entity

 

external

 

The text of the documents is stored in files and pointers to the files are stored in one of the table columns. The pointers can be operating system directories/file names or Uniform Resource Locationss (URLs). Each row is indexed by ConText as a separate entity.

 

You can use the following methods for loading documents into a table:

You can also use a ConText server with the Loader personality to automate loading text from operating system files into a LONG or LONG RAW column.

The tool/utility you use depends on the structure and usage of the text column. For example, ctxload only works for tables containing a LONG or LONG RAW column.

See Also:

Oracle7 Server SQL Reference, Oracle7 Server Utilities, Oracle ConText Option Administrator's Guide

 

3. Is ConText installed?

YES:

Proceed to Question 4 >

NO:

You must install Oracle ConText Option on a server machine.

See Also:

Oracle7 installation documentation specific to your operating system

 

4. Is the ConText initialization parameter enabled?

YES:

Proceed to Question 5 >

NO:

If you want to use one-step queries in ConText, you need to set the initialization parameter TEXT_ENABLE to TRUE.

You can set the TEXT_ENABLE parameter by adding the following line to your initsid.ora file and restarting the database:

	text_enable = true

You can also use the SQL command, ALTER SESSION, to set TEXT_ENABLE for the current session.

See Also:

Oracle7 installation documentation specific to your operating system

 

5. Is CTXAPP granted to users who own tables?

YES:

You are done with the required implementation tasks for ConText!

Go to Chapter 2, "Using Text Queries" or Chapter 3, "Using Theme Queries and the Linguistic Services" >>

NO:

You must grant the ConText role, CTXAPP, to Oracle users who own the tables in which text is stored. The CTXAPP role allows a user to create a text index for a column.

To grant CTXAPP to users, log in to SQL*Plus as the CTXSYS user and use the GRANT command.

For example:

	grant CTXAPP to CTXDEV;

In this example, CTXAPP is granted to a user named ctxdev.


Note:

ctxdev is an example Oracle user used in QuickStart; the ctxdev user is not provided by ConText and must be created manually if you wish to use it in your installation.

 

See Also:

Oracle7 Server SQL Reference, Oracle ConText Option Administrator's Guide

 



Go to previous file in sequence Prev Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents