My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Text - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.


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.


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

- This was tested against Oracle Text, and
- 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.


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

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