Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle µ¼Èëµ¼³ö¹æÔò

Ò»¡¢Á¬½Ó¹æÔò£¬Ò»ÇвÙ×÷µÄÇ°Ìá¡£ µÍ°æ±¾¿Í»§¶ËÄܹ»Á¬½Óµ½Í¬Ñù°æ±¾»òÕ߸ü¸ß°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimpºÍexp²Ù×÷¡£ ¸ß°æ±¾¿Í»§¶Ë²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimp»òÕßemp²Ù×÷¡£ ¶þ¡¢»ìºÏʹÓùæÔò£¬Ç°ÌáÊÇÒªÂú×ãÁ¬½Ó¹æÔò¡£ µÍ°æ±¾exp³öµÄdmpÎļþ£¬Óø߰汾Äܹ»imp½øÈ¥¡£ ¸ß°æ±¾exp³öµÄdmpÎļþ£¬µÍ°æ±¾µÄimp¹¤¾ß² ......

Oracle PL/SQL±à³Ì¹æ·¶Ö¸ÄÏ

Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......

ÍêÈ«¸ÉµôOracleËÀËø½ø³Ì


ÍêÈ«¸ÉµôOracleËÀËø½ø³Ì
1.²éÄĸö¹ý³Ì±»Ëø:
²éV$DB_OBJECT_CACHEÊÓͼ:SELECT * from V$DB_OBJECT_CACHE WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND CLOCKS!='0';
2. ²éÊÇÄÄÒ»¸öSID,ͨ¹ýSID¿ÉÖªµÀÊÇÄĸöSESSION:
²éV$ACCESSÊÓͼ:SELECT * from V$ACCESS WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND NAME='¸Õ²Å²éµ½µÄ¹ý³ÌÃû';
3. ²é³öSI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ