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 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]Information in this document applies to any platform.
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.
- 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 |