Loading the Text

The default indexing behavior expects documents loaded in a text column, although you can also store your documents in other ways, including the file system and as a URL (see the Data Store options).

Column Types

By default, the system expects your documents to be loaded in a text column. Your text column can be VARCHAR2, CLOB, BLOB, CHAR, or BFILE.

Note that storing data in the deprecated column types of LONG and LONG RAW is supported only for migrating Oracle7 systems to Oracle8. The column types NCLOB, DATE and NUMBER cannot be indexed.

Document Formats

Because the system can index most document formats including HTML, PDF, Microsoft Word, and plain text, you can load any of these document types into the text column. (See the Filter options.) For more information about the supported document formats, see Appendix C, "Supported Filter Formats", in the Oracle interMedia Text User's Guide and Reference.

Loading Methods

You can load data using various methods, including:

For information and examples of using SQL*Loader or ctxload, see the Oracle interMedia Text User's Guide and Reference.

For information about the DBMS_LOB package, see Oracle8i Supplied Packages Reference.

For information about working with LOBs, see the Oracle8i Application Developer's Guide - Large Objects (LOBs).

For information about Oracle Call Interface, see the Oracle Call Interface Programmer's Guide.

See also: Main topics (outline), Getting started with interMedia Text