oracleÈ«ÎÄË÷ÒýºÍ¶¨Ê±ÈÎÎñ
--Ê×Ïȼì²éÊý¾Ý¿âÖÐÊÇ·ñÓÐCTXSYSÓû§ºÍCTXAPP½ÅÉ«¡£
--Èç¹ûûÓÐÕâ¸öÓû§ºÍ½ÇÉ«£¬Òâζ×ÅÄãµÄÊý¾Ý¿â´´½¨Ê±Î´°²×°intermedia¹¦ÄÜ¡£
--Äã±ØÐëÐÞ¸ÄÊý¾Ý¿âÒÔ°²×°ÕâÏÄÜ¡£
--ÓÃsysÓû§ÎªÁËÓû§gzinfo·ÖÅäȨÏÞ
grant
CTXAPP
to
gzinfo;
grant
execute
on
ctx_ddl
to
gzinfo;
--»Øµ½gzinfoÓû§
--´´½¨²âÊÔ±í,CLOBTEXT×Ö¶ÎΪÐèÒªË÷ÒýµÄ×Ö¶Î
create
table
INXTEXT (ID
number
(
13
), CLOBTEXT CLOB);
--´´½¨·Ö´Ê,ÕâÀïÓÃÁËchinese_vgram_lexer,·Ö´ÊÃûΪGZINFO_LEXER
call ctx_ddl.create_preference (
'
GZINFO_LEXER
'
,
'
chinese_vgram_lexer
'
);
--´´½¨Ë÷Òý,Ë÷ÒýÃûΪINX_TEST (PARAMETERS ÖÐÐèÒªÒÔLEXER¿ªÍ·,Ì滻ʱÓÃreplace)
create
index
INX_TEST
ON
INXTEXT (CLOBTEXT) INDEXTYPE
IS
CTXSYS.CONTEXT PARAMETERS (
'
LEXER INFO_LEXER
'
);
--´´½¨¼Ç¼±í
create
table
JOBTEST (ID DATE, CONTENT
VARCHAR2
(
200
));
--´´½¨Í¬²½´æ´¢¹ý³Ì,ctx_ddl.sync_index('INX_TEST')Ϊͬ²½È«ÎÄË÷Òý,ͬ²½±í×Ö¶ÎÖеÄÐÅÏ¢
create
or
replace
procedure
PROC_SYNC_INDEX
is
begin
ctx_ddl.sync_index(
'
INX_TEST
'
);
insert
into
JOBTEST
values
(SYSDATE,
'
ͬ²½ÈÎÎñÓÚ
'
||
SYSDATE
||
'
Ö´ÐÐ
'
);
end
;
--´´½¨Í¬²½ÓÅ»¯´æ´¢¹ý³Ì,ctx_ddl.optimize_index('INX_TEST','FULL')ΪÓÅ»¯È«ÎÄË÷Òý
Code
create
or
replace
procedure
PROC_SYNC_OPTIMIZE
is
begin
ctx_ddl.sync_index(
'
INX_TEST
'
);
ctx_ddl.optimize_index(
'
INX_TEST
'
,
'
FULL
'
);
insert
into
JOBTEST
values
(SYSDATE,
'
ͬ²½ÓÅ»¯ÈÎÎñÓÚ
'
||
SYSDATE
||
'
Ö´ÐÐ
'
);
end
;
--´´½¨¶¨Ê±ÈÎÎñÒÔ±ãͬ²½È«ÎÄË÷Òý
DECLARE
X
NUMBER
;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job &n
Ïà¹ØÎĵµ£º
ϵͳ»¹Ô¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½ ......
ÔںܶàÆóÒµ¼¶°²×°Êý¾Ý¿âʱ£¬³£³£Óдó¹æÄ£µÄ°²×°ÈÎÎñ£¬ÕâʱʹÓÃÏìÓ¦ÎļþÀ´ÅúÁ¿°²×°¿ÉÒÔÌá¸ß¹¤×÷ЧÂÊ£¬ÏÂÃæ½éÉÜÊý¾Ý¿âÈí¼þµÄ¾²Ä¬°²×°·½Ê½¡£
Ò»¡¢Êý¾Ý¿â·þÎñÆ÷¶Ë°²×°
1. Éú³É°²×°ÏìÓ¦Îļþ
$./runInstaller -record -destinationFile /tmp/install_database_10g.rsp
Õâʱ»áÆô¶¯Í¼ÐνçÃæÀ´Â¼ÖÆÎÒÃÇÐèÒªµÄÏìÓ¦Îļþ¡£
×¢Ò⣺
......
http://www.haoxiai.net/shujuku/Oracle/111145.html
Ò»¡¢Êý¾Ý¿âÃû
ʲôÊÇÊý¾Ý¿âÃû
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²ÎÊýDB_NAME±»Ð´Èë²ÎÊýÎļþÖ®ÖС£¸ñʽÈçÏ£º
DB_NAME=m ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ× ......
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
sysdate+5/24 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
sysdate+5 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
add_months(sysdate,-5) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
add_months(sysdate,-5*12) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
ÉÏÔÂÄ©µÄÈÕÆÚ£ºselect last_day(add_mon ......