My Oracle Support Banner

How to Load Binary Files into a Table and Create a Text Index (Doc ID 115729.1)

Last updated on APRIL 01, 2020

Applies to:

Oracle Text - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 24-JUL-2012***


Purpose

The following article describes how to load binary files, e.g. MS Word documents, into a table and create a Text index on that table.

Scope

This note is intended to be used as a guideline for creating Text indexes whose document format is binary.

Note:
- This was tested against Oracle Text 9.2.0.7, 10.2.0.2 and 11.1.0.6
- It is assumed the reader has set up Oracle Text (Text) and the user CTXSYS has been created
- This testcase was created on a UNIX machine; therefore, all filenames and directory structures are coded using UNIX conventions. However, with the appropriate updates, this procedure will run on MS Windows OS as well.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.