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

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

Oracle Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊÇ×î¼òµ¥µÄ£¬Ä¬ÈÏÊǾÍÊÇÓÃÕâÖÖÀàÐÍ
OracleµÄÈ«ÎÄË÷Òý²»ÒªÇó±»Ë÷ÒýµÄÎÄÕÂÒ»¶¨´æ´¢ÔÚÊý¾Ý¿âÖУ¬²»¹ýÈç¹ûÎÄÕ´洢ÔÚÊý¾Ý¿âµÄÒ»ÁÐÖУ¬ÄÇôÕâÖÖÇé
¿ö½¨Á¢Ë÷ÒýÊÇ×î¼òµ¥µÄ¡£
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(4000));
±íÒÑ´´½¨¡£
SQL> INSERT INTO T VALUES (1, 'This is a sample for Oracle TEXT.');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (2, 'This is a direct database store sample');
ÒÑ´´½¨ 1 ÐС£
SQL> COMMIT;
Ìá½»Íê³É¡£
¶ÔÓÚÉÏÃæÌáµ½µÄDIRECT DATASTOREÀàÐÍ£¬ÏÂÃæÈýÖÖ´´½¨Ë÷Òý·½Ê½Êǵȼ۵ģº
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT;
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'DATABASE') > 0;
ID DOCS
---------- ----------------------------------------
2 This is a direct database store sample
SQL> DROP INDEX IND_T_DOCS;
Ë÷ÒýÒѶªÆú¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('DATASTORE CTXSYS.DEFAULT_DATASTORE');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'DATABASE') > 0;
ID DOCS
---------- ----------------------------------------
2 This is a direct database store sample
SQL> DROP INDEX IND_T_DOCS;
Ë÷ÒýÒѶªÆú¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('DATASTORE CTXSYS.DIRECT_DATASTORE');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'DATABASE') > 0;
ID DOCS
---------- ----------------------------------------
2 This is a direct database store sample
ÉÏÃæ¸ø³öÁËÒ»¸ö×î¼òµ¥µÄÈ«ÎÄË÷ÒýµÄÀý×Ó¡£
ÁíÍ⣬ÓÉDR$¿ªÍ·µÄ4ÕűíÊÇϵͳΪÁËÖ§³ÖÈ«ÎÄË÷Òý¶ø×Ô¶¯Éú³ÉµÄ£¬²»¹ýÕâ4ÕűíµÄÓô¦¾Í²»ÔÙÕâÀïÌÖÂÛÁË¡£
SQL> SELECT * from TAB;
TNAME TABTYPE CLUSTERID
------------------------------ -------


Ïà¹ØÎĵµ£º

suseϵͳÏ£ºoracle ´Ó10.2.0.2 µ½ 10.2.0.4 Éý¼¶Ïê½â

oracle ´Ó10.2.0.2 µ½ 10.2.0.4 Éý¼¶
Ò»¡¢ÏÂÔØÉý¼¶°ü
ÏÂÔصØÖ·£º
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
×¢Ò⣺²»ÒªÓÃflashgetÏÂÔØ£¬ÓÃѸÀ×ÏÂÔØ¡£Îļþ´óС1G¶à¡£
¶þ¡¢¹Ø±ÕÊý¾Ý¿â
ÒÔoracleÓû§Ô¶³ÌµÇ¼suseϵͳ:
 1. sqlplus /nolog
 SQL> connect /as sysdba
 SQL> ......

ORACLE JOB »ã×Ü

Ò»¡£jobµÄÔËÐÐƵÂÊÉèÖÃ
1.ÿÌì¹Ì¶¨Ê±¼äÔËÐУ¬±ÈÈçÔçÉÏ8:10·ÖÖÓ£ºTrunc(Sysdate+1) + (8*60+10)/24*60
2.ToadÖÐÌṩµÄ£º
ÿÌ죺trunc(sysdate+1)
ÿÖÜ£ºtrunc(sysdate+7)
ÿÔ£ºtrunc(sysdate+30)
ÿ¸öÐÇÆÚÈÕ£ºnext_day(trunc(sysdate),'SUNDAY')
ÿÌì6µã£ºtrunc(sysdate+1)+6/24
°ë¸öСʱ£ºsysdate+30/1440
3.ÿ¸ö ......

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



¼ÌÐøÌÖÂÛÈ«ÎÄË÷ÒýµÄDATASTOREÊôÐÔ£¬½éÉÜMULTI_COLUMN_DATASTORE¡£
Èç¹û±»Ë÷ÒýµÄÎÄÕÂÊDZ£´æÔÚÊý¾Ý¿âÖУ¬µ«ÊÇÄÚÈÝ·Ö²¼ÔÚ¶à¸öÁÐÖУ¬ÄÇô¿ÉÒÔͨ¹ý½¨Á¢Ò»¸öMULTI_COLUMN_DATASTOREÀ´Ë÷ÒýÍêÕûµÄÎÄÕ£º
SQL> CREATE TABLE T (ID NUMBER, DOC1 VARCHAR2(4000), DOC2 VARCHAR2(4000), DOC3 VARCHAR2(4000));
±íÒÑ´´½ ......

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

DATASTOREÊÇFILE_DATASTOREµÄ²âÊÔ
[oracle@rhel140 ~]$ cat OUTPUT.TXT
ORACLE
oracle
[oracle@rhel140 LOG]$ cat EMPXT_000_2012_2680.LOG
SOURCE
ABC
SQL> conn myuser/myuser
Connected.
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'OUT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ