CTXAPP Role The CTXAPP role is a system-defined role that enables users to do the following: create and delete interMedia Text preferences use the interMedia Text PL/SQL packages Any user can create an interMedia Text index and issue a Text query. The CTXAPP role allows users create preferences and use the PL/SQL packages. ------------------------------------------------------------------ Supported 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: 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. 对于楼上问题不存版本问题,能建blob建立词索引,应该可以BFILE建立词索引,请问楼主,bfile存了什么数据?
小问题小技巧可以问,这么大的主题,如果自己没有一点基础的话,靠网友回答太难了,相信我,回家看书去吧。
http://www.itpub.net/showthread.php?s=&threadid=25259&highlight=%B5%B9%D0%F2%CB%F7%D2%FD
要对BFILE字段索引,我已说过,索引建立起了,主要是找不到索引词。如果是BLOB字段就不存在这样的问题了
看过好多技术文章,但都没对BFILE进行专门介绍的,yuaiwu???你用过Bfile的索引??
The CTXAPP role is a system-defined role that enables users to do the following: create and delete interMedia Text preferences use the interMedia Text PL/SQL packages Any user can create an interMedia Text index and issue a Text query. The CTXAPP role allows users create preferences and use the PL/SQL packages.
------------------------------------------------------------------
Supported 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:
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.
对于楼上问题不存版本问题,能建blob建立词索引,应该可以BFILE建立词索引,请问楼主,bfile存了什么数据?
如果有InterMedia相关资料,建议使用InterMidia,处理.
涉及抽象数据类型,Oracle的'安装目录下有例子.如果有数据库高手,你可以用Java写存储过程,建立自定义的索引.