解析：Oracle建立二进制文件索引的方法

CREATE TABLE ZYCONTENT_TABLE(
　NAME VARCHAR(128) UNIQUE NOT NULL,
　MIME_TYPE VARCHAR(128),
　DOC_SIZE NUMBER,
　DAD_CHARSET VARCHAR(128),
　LAST_UPDATED DATE,
　CONTENT_TYPE VARCHAR(128),
　CONTENT LONG RAW,
　BLOB_CONTENT BLOB 
);

GRANT "CTXAPP" TO "ZYFILEUP";
ALTER USER "ZYFILEUP" DEFAULT ROLE ALL;
GRANT EXECUTE ON "CTXSYS"."CTX_ADM" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_CATSEARCH" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_CONTAINS" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_DDL" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_DOC" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_QUERY" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_ULEXER" TO "ZYFILEUP";
GRANT EXECUTE ON "CTXSYS"."CTX_XPCONTAINS" TO "ZYFILEUP";

begin
ctx_ddl.create_preference('mylex','BASIC_LEXER');
ctx_ddl.set_attribute('mylex','printjoins','_-');
ctx_ddl.create_preference('mywordlist', 'BASIC_WORDLIST');
ctx_ddl.set_attribute('mywordlist','PREFIX_INDEX','TRUE');
ctx_ddl.set_attribute('mywordlist','PREFIX_MIN_LENGTH',1);
ctx_ddl.set_attribute('mywordlist','PREFIX_MAX_LENGTH', 5);
ctx_ddl.set_attribute('mywordlist','SUBSTRING_INDEX', 'YES');
end;
begin
ctx_ddl.create_preference('cnlex','CHINESE_LEXER');
end;

drop index i_zycontent_table force;
create index i_zycontent_table 
on zycontent_table(blob_content) 
indextype is ctxsys.context 
parameters ('DATASTORE CTXSYS.DIRECT_DATASTORE 
FILTER CTXSYS.INSO_FILTER 
LEXER ZYFILEUP.CNLEX 
WORDLIST ZYFILEUP.MYWORDLIST');