Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Öе¼Èëµ¼³ödmpÊý¾Ý¿âÎļþ

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃü Áî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
¡¡ ......

Oracle 1z0 033 ÈÏÖ¤¿¼Ìâ×ÊÁÏ

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²»½öÔÚÈ«Çò× ......

install oracle 10.0.2.0.4 on mac10.5.8

¾­¹ýÁ½ÌìµÄµ¹ÌÚÖÕÓÚÔÚmacÉÏ×°ºÃoracle10g ÁË¡£ÕâÏÂÍêÃÀÁË++
½Ì³ÌÍøÉÏÓкܺã¬×Ô¼ºÒ²²»¼ÇµÃ²ÎÕÕ¹ý¶àÉÙƪÁË¡£
Ö»¼ÇÏÂ×Ô¼ºÅöµ½µÄÎÊÌâµã¡£
1,×éÎÊÌâ¡£
  ÍêÈ«ÊǸöÈËʹÓã¬ËùÒÔÎÒûÓл¨ÄǸöÏй¤·òȥн¨Ò»´ó¶Ñ×éºÍÓû§£¬
 Ïà·´£¬ÎÒ¾ÍÊÇÄõ±Ç°Óû§×°µÄ£¬Ö»²»¹ý£¬°Ñµ±Ç°Óû§Ò²¼ÓÈëÁËROOT×飬Õâ¸ö±È½ÏºÝ¡£
2£¬ÓеĽ ......

Oracle 10G Êý¾Ý¿âÎļþĿ¼½á¹¹

ÔÚ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½øÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ