Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
CTX_THES Package , 3 of 30
Use this procedure to rename or truncate an existing thesaurus. Only the thesaurus owner or CTXSYS can invoke this function on a given thesaurus.
CTX_THES.ALTER_THESAURUS(tname in varchar2, op in varchar2, operand in varchar2 default null);
Specify the thesaurus name.
Specify the alter operation as a string or symbol. You can specify one of two operations:
op | Meaning | operand |
---|---|---|
CTX_THES.OP_RENAME |
Rename thesaurus. Returns an error if the new name already exists. |
Specify new thesaurus name. |
CTX_THES.OP_TRUNCATE |
Truncate thesaurus. |
None. |
Specify the argument to the alter operation. See table for op.
Rename thesaurus THES1 to MEDICAL:
ctx_thes.alter_thesaurus('thes1', 'rename', 'medical');
or
ctx_thes.alter_thesaurus('thes1', ctx_thes.op_rename, 'medical');
You can use symbols for any op argument, but all further examples will use strings.
Remove all phrases and relations from thesaurus THES1:
ctx_thes.alter_thesaurus('thes1', 'truncate');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|