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

oracleÈ«ÎÄË÷Òý֮ͣÓôʵÄͨÅä·û¹¦ÄÜ

È«ÎÄË÷ÒýÍ£ÓôʵÄÉèÖÃÔÚÇ°ÃæµÄÎÄÕÂÖÐÒѾ­½éÉܹýÁË£¬ÕâÀï¼òµ¥ËµÃ÷¼Ç¼һÏÂÍ£ÓôÊÔÚ²éѯʱºòÐèҪעÒâµÄµØ·½¡£
Oracle10gÖУ¬Èç¹û°²×°ÓïÑÔΪÖÐÎÄ£¬Ä¬ÈϵÄLEXERΪCHINESE_VGRAM_LEXER£¬Ä¬ÈϵÄÍ£ÓôÊÓïÑÔҲΪÖÐÎÄ¡£ÕâÆªÍ¨¹ý¶Ô±ÈÖÐÎÄ»·¾³ºÍÓ¢ÎÄ»·¾³À´ËµÃ÷Í£ÓôʲéѯµÄÒ»Ð©ÌØµã¡£
SQL> show user
USER is "MYUSER"
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'This example test stopword.');
1 row created.
SQL> INSERT INTO T VALUES (2, 'Oracle9i chinese language environment default stopword are english.');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> CREATE INDEX IND_T_DOCS ON T(DOCS) INDEXTYPE IS CTXSYS.CONTEXT;
Index created.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'This') > 0;
no rows selected
Ó¢ÎÄ»·¾³ÏÂÔÊÐíµ¥¶À²éѯͣÓôʣ¬µ«ÊDz»»á·µ»Ø½á¹û¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'are english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'is english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'stopword are english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'stopword is english') > 0;
ID DOCS
--- --------------------------------------------------
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'are stopword') > 0;
ID DOCS
--- --------------------------------------------------
1 This example test stopword.
2 Oracle9i chinese language environment default stop
word are english.
SQL> SELECT * from T WHERE CONTAINS(DOCS, '


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

¡¾×ª¡¿ÓÅ»¯OracleÊý¾Ý¿âÐÔÄÜ

 ¡¾IT168 ¼¼ÊõÎĵµ¡¿Ëæ×ÅÍøÂçÓ¦Óú͵ç×ÓÉÌÎñµÄ²»¶Ï·¢Õ¹£¬¸÷¸öÕ¾µãµÄ·ÃÎÊÁ¿Ô½À´Ô½´ó£¬ÈçºÎʹÓÐÏ޵ļÆËã»úϵͳ×ÊԴΪ¸ü¶àµÄÓû§·þÎñ£¿ÈçºÎ±£Ö¤Óû§µÄÏìÓ¦ËٶȺͷþÎñÖÊÁ¿£¿ÕâЩÎÊÌâ¶¼ÊôÓÚ·þÎñÆ÷ÐÔÄÜÓÅ»¯µÄ·¶³ë¡£×÷Ϊ½Ï³É¹¦µÄÊý¾Ý¿â³§ÉÌ£¬Oracle¹«Ë¾Êý¾Ý¿âµÄÐÔÄÜÓÅ»¯ÊÇÈçºÎ½øÐеÄ
¡¡¡¡ ÓÅ»¯²ßÂÔ
¡¡¡¡ ΪÁ˱£Ö¤OracleÊý ......

Oracle´´½¨Êý¾Ý¿âͬÒå´Ê

1.ÔÚAÓû§ÏÂÊÚȨ“ÉÌ»§ÐÅÏ¢±í”¸øBÓû§
grant all on TBL_INF_MCHNT_INF to B;
commit;
2.ÔÚBÓû§Ï½¨Á¢Í¬Òå´Ê
create synonym TBL_INF_MCHNT_INF for A.TBL_INF_MCHNT_INF;
3. ²éѯÊý¾Ý¿âËùÓÐͬÒå´Êselect * from sys.synonyms ......

oracleÈ«ÎÄË÷ÒýÖ®datastore_1_DIRECT_DATASTORE

Oracle Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ