Document Loading

Pre-8.1

You use the ctxload executable to load documents into LONG or LONG RAW text columns. You also use it to import thesauri.

8.1

ctxload

In 8.1, ctxload still supports the loading of LONGs and LONG RAWs as well as importing thesauri.

Suggestion: If your pre-8.1 application uses LONG or LONG RAW to store your documents, Oracle recommends that you migrate these columns to LOBs. To do so, you can use the SQL operator TO_LOB. For more information about migrating your LONGs and LONG RAWs to LOBs, see Oracle8i Migration. For more information about loading LONGs with ctxload, see Oracle8i interMedia Text Reference.

SQL*Loader

In 8.1, you can store documents in the columns types of CHAR, CLOB, BLOB, BFILE, or VARCHAR2. To load documents to any of these data types, you can use SQL*Loader.

See Also: For an example of using SQL*Loader, see Oracle8i interMedia Text Reference.