EXPORT_THESAURUS

Use this procedure to export a thesaurus as a clob from the Oracle Text thesaurus tables. The format of the exported thesaurus is same as that of the format of the thesaurus file that is used by the ctxload utility to import thesaurus into the Oracle Text thesaurus tables.

See Also: “Thesaurus Loader (ctxload)” in Oracle Text Utilities for more information about the ctxload utility.

Only the owner of the thesaurus, or the sys user, or the ctxsys user can export a thesaurus from the Oracle Text thesaurus tables using export_thesaurus.

You should call ctx_output.start_log before calling export_thesaurus to log the operations done by export_thesaurus.

Syntax

CTX_THES.EXPORT_THESAURUS(name in varchar2,
                          thesdump in out nocopy CLOB);

name

Specify the name of the thesaurus in the Oracle Text thesaurus tables that you want to export. If the specified thesaurus does not exists in the Oracle Text thesaurus tables, then this procedure raises an exception.

thedump

Specify the name of the clob where you want to store the thesaurus that is exported from the Oracle Text thesaurus tables.

Example

The following example copies the thesaurus named mythesaurus from the Oracle Text thesaurus tables into the clob mythesdump:

declare
 mythesdump clob;
begin
 ctx_thes.export_thesaurus('mythesaurus', mythesdump);
end;