Oracle Context Option QuickStart

Library

Product

Contents

CHAPTER 4. Implementing ConText Option

Pre-implementation Checklist
Implementation Questions

This chapter provides information for quickly and easily implementing ConText Option.

The chapter covers the following topics:

Pre-implementation Checklist

Implementation Questions

Pre-implementation Checklist

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

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

Task
[ ] Oracle installed and running
[ ] Tablespaces created
[ ] Oracle users created and granted necessary database roles

Table 4 - 1. Oracle ConText Option Pre-implementation Checklist

Attention: The Oracle user who performs the QuickStart implementation must have the CONNECT and RESOURCE roles.

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

Implementation Questions

This section provides a list of ConText Option 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 Oracle ConText Option installed?

4. Is the ConText Option initialization parameter enabled?

5. Is CTXAPP granted to users who own tables?

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

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:

primary key (one or more columns that uniquely identify each document)

column for storing text (recommended datatypes: CHAR, VARCHAR2, LONG, or LONG RAW)

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

Additional Information:
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 Option supports three types of storage for documents:

internal (each document stored in database table as a single row, with the text of the documents stored in table column)

internal master/detail (documents stored in database table as multiple rows, with the text of the documents stored in table column)

external (documents stored in operating system files, with file pointers or URLs stored in table column)

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

INSERT (SQL command) for loading a single block of plain (ASCII) text into a row

SQL*Loader for batch loading plain (ASCII) text

ctxload (utility provided with ConText Option) for batch loading plain and formatted text into LONG and LONG RAW columns

You can also use a ConText server with the Loader personality to load text into a text column. The Loader personality scans a specified directory for incoming files and calls the ctxload utility to load the contents of the files (or the file pointers/URLs, if external storage is specified) into the appropriate 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 text column that is used to store the text.

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

3. Is Oracle ConText Option installed?

YES -

Proceed to Question 4 >

NO -

You need to install Oracle ConText Option on a server machine.

Additional Information:
Oracle7 Server installation documentation specific to your operating system

4. Is the ConText Option initialization parameter enabled?

YES -

Proceed to Question 5 >

NO -

If you want to use one-step queries in ConText Option, 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.

Additional Information:
Oracle7 Server 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 Oracle ConText Option!

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

NO -

You need to grant the CTXAPP role 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 the CTXAPP role 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.

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

Library

Product

Contents

Task
[ ]	Oracle installed and running
[ ]	Tablespaces created
[ ]	Oracle users created and granted necessary database roles