Oracle TextÔâÓöÕ½[2009 12 31 16:15]
ÊÖÍ·ÕýÔÚ½øÐÐÒ»¸öÏîÄ¿£¬ÐèҪȫÎļìË÷£¬¾¹ýͬÊÂ×ÐϸËÑË÷·¢ÏÖ£ºoracleÌṩoracle textµÄÈ«ÎļìË÷¹¦ÄÜ¡£
oracle textµÄ¼òµ¥Ó¦ÓþͬʲâÊÔ½á¹ûÕý³££¬°´ÕÕÏîÄ¿ÒªÇó(ÏîÄ¿Ô¤¶¨·½°¸wordÎĵµ´æÈëÊý¾Ý¿â(blobÀàÐÍ))ʹÓÃoracle text²éѯ½á¹ûÈ·ÊÇΪ¿Õ£¬Í¬ÊÂÑо¿µ½´ËÖжϡ£
BOSS¼ûÎÒ¶ÔoracleÐËȤŨºñ£¬ÈÃÎÒ½ÓÊÖ£¬ÓÚÊÇÎÒÁÙʱ±§·ð½Å¿ªÊ¼Ñ§Ï°oracle text£¬×ÁÄ¥³öһЩ´ó¸ÅÍ·Ð÷£¬²½ÖèÈçÏ£º1)ÊÚȨctxsys½ÇÉ«£»2)½¨±í£»3)ÉèÖÃË÷Òý²ÎÊý¡¢´´½¨Ë÷Òý£»4)²éѯ¡£Í·Ð÷¹éÍ·Ð÷£¬µ«ÊÇ¿¨×¡Í¬ÊµÄÎÊÌâͬÑù¿¨×¡ÎÒ£¬ÎÒ¿ªÊ¼»³ÒÉstringÐÍÎÞ·¨ÓëblobÐÍÆ¥Åä²éѯ£¬ºóÓÖ·¢ÏÖÐí¶àÈ˶¼ÊÇÖ±½Ó½«×Ö·û´®²åÈëblobÐÍÁУ¬ÖÁ´ËÏÝÈëÃÔ㣬×îÖÕ¾ö¶¨ÔÚCSDN·¢ÌûÇóÖú£¬¾Ò»Î»ÈÈÐÄÈË(Ôڴ˸ÐлCSDNµÄDenonly )ÌáʾwordÎĵµ×ª»¯Îª¶þ½øÖƺóµÃµ½µÄ¿ÉÄܲ»È«ÊÇÎı¾ÄÚÈÝ£¬ÖÕ´óÎò£¡
ºóÈÃͬÊ°ÑÒ»¸öTXTÎı¾×ª»¯ºó´æÈëÊý¾Ý¿â£¬Ê¹ÓÃÀÏ·½·¨²éѯ£¬²éѯ½á¹ûÕýÈ·£¡´óϲ£¡²éѯ¹ý³Ì¿ÉÐУ¬ÎÊÌâ¿Ï¶¨ÔÚblob£¡
²»¹ý;ÖÐÓÖ×ßÁËһЩÍä·£¬oracleÖд洢ÍⲿOSÎļþ·¾¶£¬oracle textÖ±½Ó¶ÔÕâЩÎļþ¼ìË÷£¬¿ÉϧûÄÜÖ¤Ã÷¿ÉÐл¹ÊDz»¿ÉÐУ¬ÁôÏÂÒ»¸öÐüÄî¡£
¾¹ý°Ù¶ÈµÄÂÒÆß°ËÔãËÑË÷·¢ÏÖÒ»¸öÌû×Ó£¬ÉÏÃæ²ûÊöÁËÔÚ´´½¨Ë÷ÒýÇ°É趨²»Í¬filetrÑ¡ÏîµÄЧ¹û£¬ÆäÖÐCTXSYS.INSO_FILTER¿ÉÒÔ¶ÔһЩ¶þ½øÖÆÎļþµÄÎı¾²¿·ÖºÍ·ÇÎı¾²¿·Ö¹ýÂË·ÖÀ룬°Ù¶ÈµÃµ½Ò»Ð©ÓÅ»¯¼ìË÷µÄÉèÖã¬ÔÚ´´½¨Ë÷Òýʱ¼ÓÈëFILTERÑ¡ÏîµÄÉèÖã¬Ôٴγ¢ÊÔ¼ìË÷£¬ÖÕÓÚOK.......ÄÚÅ£ÂúÃæ
Ìù³ö½Å±¾£º
--ÓÅ»¯¼ìË÷Ìõ¼þ
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 t_fileinfo_idx force;
create index t_fileinfo_idx on fileinfo(text)
indextype is ctxsys.context
parameters ('DATASTORE CTXSYS.DIRECT_DATASTORE FILTER C
Ïà¹ØÎĵµ£º
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃü Áî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
¡¡ ......
Oracle 1z0-033 ÈÈÃÅÈÏÖ¤
1z0-033 Exam
Oracle9i Database:Performance Tuning
¿ÆÄ¿±àºÅ£º1z0-033
¿ÆÄ¿Ãû³Æ£ºOracle 9i Database:Performance Tuning
¿¼ÊÔ¼Û¸ñ£ºCNY898
¿¼ÊÔʱ¼ä£º120·ÖÖÓ
¿¼ÌâÊýÁ¿£º65
¼°¸ñ·ÖÊý£º72£¥
¸üÐÂÈÕÆÚ£º2010-01-23
Oracle 1z0-033 ÊÇÒ»¸öÅÓ´óµÄÆ·ÅÆϵͳ¡£ÈçÇ°ËùÊö£¬Oracle²»½öÔÚÈ«Çò× ......
¾¹ýÁ½ÌìµÄµ¹ÌÚÖÕÓÚÔÚmacÉÏ×°ºÃoracle10g ÁË¡£ÕâÏÂÍêÃÀÁË++
½Ì³ÌÍøÉÏÓкܺã¬×Ô¼ºÒ²²»¼ÇµÃ²ÎÕÕ¹ý¶àÉÙƪÁË¡£
Ö»¼ÇÏÂ×Ô¼ºÅöµ½µÄÎÊÌâµã¡£
1,×éÎÊÌâ¡£
ÍêÈ«ÊǸöÈËʹÓã¬ËùÒÔÎÒûÓл¨ÄǸöÏй¤·òȥн¨Ò»´ó¶Ñ×éºÍÓû§£¬
Ïà·´£¬ÎÒ¾ÍÊÇÄõ±Ç°Óû§×°µÄ£¬Ö»²»¹ý£¬°Ñµ±Ç°Óû§Ò²¼ÓÈëÁËROOT×飬Õâ¸ö±È½ÏºÝ¡£
2£¬ÓеĽ ......
ÔÚOracle Database 10gÖÐ,OracleµÄĿ¼½á¹¹ÊÇÓÉOracle_Base¼°Æä×ÓĿ¼Oracle_Home¡¢admin¡¢flash_recovery_areaºÍoradataĿ¼¹¹³ÉµÄ¡£Îª·½±ãÌÖÂÛ£¬ÓÃOracle_Base´ú±íOracleĿ¼Ê÷µÄ¸ù£¬ÓÃOracle_Home±íʾ¸ùĿ¼ÏµÄÖ÷Ŀ¼¡£
1.Oracle_BaseĿ¼
Oracle_Base´ú±íOracleĿ¼Ê÷µÄ¸ù¡£Èç¹ûʹÓÃOracle Universal Installer½øÐ ......