Re: Oracle ConText Option

>Hi,
>I am using the Oracle ConText option in an Oracle web based application.
>I am able to successfully perform all the queries when I store all the
>text data with in the database(ie. in the column). But now I am trying
>to store all the text data in a file on my operating system and just
>store the pointer or path name to that file in my database. I am not
>aware of the steps involved in doing this. How do I query if such a
>table is built. Any pointers as to where I can find this info would be
>appreciated.
>
>Can any one help me as to how this could be done?
>
>

External Text

The requirements for storing text externally are more complicated than storing text directly in a column due to the two different methods of accessing text stored in external files:

•file names using OSFILE Data Store Tile

•URLs using the URL Data Store Tile

Text Stored as File Names

For text stored as file names pointing to external files, the name and location of the file must be stored.

Directory Path Names

For external files accessed through the file system, the directory path where the files are located must be specified. The path can be stored as part of the file name either in the text column or in the Data Store preference that you create for the OSFILE Tile.

Note: If the preference does not contain the directory path for the files, ConText Option requires the directory path to be included as part of the file name stored in the text column.

File Access

All the external files referenced in the column must be accessible from the server machine on which the ConText server is running. This can be accomplished by storing the files locally in the file system for the server machine or by mounting the remote file system to the server machine.

File Permissions

File permissions for external files in which text is stored must be set accordingly to allow ConText Option to access the files. If the file permissions are not set properly for a file and ConText Option cannot access the file, the file cannot be indexed or retrieved by ConText Option.

Text Stored as URLs

For external Web files, the complete address for each file must be stored as a URL in the text column and the URL Tile utilized in the policy for the column.

Note: Text that contains HTML tags and is stored directly in a text column is considered internal text. As such, the Data Store preference for the text column policy would use the DIRECT or MASTER DETAIL Tiles.

In addition, Web files can be any format supported by the World Wide Web, including HTML files, plain ASCII files, and proprietary formats such as PDF and Word. The filter for the column must be able to recognize and process any of the possible documents formats that may be encountered on the Web.

A URL consists of the protocol for accessing the Web file and the address of the file, in the following format:

        protocol://file_address

The ConText Option URL data store supports two protocols:

•hypertext transfer protocol (HTTP)

•file protocol

Hope this helps,
Tim Received on Thu Nov 27 1997 - 00:00:00 CST