摘要:
1.给指定用户(tecamocmsuser)授权(ctxapp和execute on ctx_ddl)grant ctxapp to tecamocmsuser;grant execute on ctx_ddl to tecamocmsuser;2创建分词ctx_ddl.create_preference ('my_LEXER', 'chinese_vgram_lexer');3创建索引CREAT... 阅读全文
摘要:
--代表来源端数据表CREATE TABLE tblOrg(c1 int primary key,c2 int,c3 nvarchar(10),c4 nvarchar(10),HashKey As CheckSum(c2,c3))CREATE INDEX idxOrgHash ON tblOrg(HashKey)--代表目的端数据表CREATE TABLE tblTar(c1 int primar... 阅读全文