oracleɾ³ý·þÎñ
°²×°oracleʱ£¬ÓÉÓÚ·´¸´°²×°Ð¶ÔØ£¬Óöµ½·þÎñûÓÐÐ¶ÔØ²»ÄܼÌÐø°²×°µÄÎÊÌ⣬´ÓÍøÉÏÕÒµ½ÁË×ÊÁÏ£¬Å¶ªÊ§ÔÚ´Ë×ªÔØÒ»Ï£¬ÄÚÈÝÈçÏÂ:
Èç¹ûÄãÒ²ºÍÎÒÒ»Ñù£¬Óù¤¾ß´´½¨ÁËÒ»¸ö·þÎñ£¬Ïëɾ³ýʱȴ·¢ÏÖɾ³ý²»µô¡£»òÕß°²×°ÁËDameWare Mini Remote ÒԺ󣨰üÀ¨×Ô¼º°²×°»òÕß»úÆ÷±»ºÚ£©ÔÚ·þÎñÀïÓÐÒ»¸ö“DameWare Mini Remote Control”¡£²»ÄÜɾ³ý¡£
±ÈÈçÄã´´½¨ÁËÒ»¸ö·þÎñi£¬ÔõÃ´É¾ÄØ£¬Èç¹ûÄãÖ±½ÓÀ´¸ösc delete i ,Äǿ϶¨»áµÃµ½ÏÂÃæµÄ´ð°¸¡£
C:\Documents and Settings\pan>sc delete i
[SC] OpenService FAILED 1060:
Òâ˼¾ÍÊÇûÓиÃʵÀý¡£¼´Ê¹ÄãÔÚ×¢²á±íÒ²²»»á²éµ½Õâ¸öµÄ¡£
1.ÏȲ鿴·þÎñµÄÃû³Æ£¬ÒòΪÄǸöiÖ»ÊÇÏÔʾµÄÃû³Æ¡£
ÓÐÈýÖÖ°ì·¨¿ÉÒÔ×öµ½Õâµã¡£
(1)×îÈÝÒ׵ķ½·¨¾ÍÊÇÔÚÔËÐÐÖÐÊäÈëservices.msc,ÕÒµ½ÄǸö¿É¶ñµÄi ,µãÓÒ¼ü£º ¿´µ½·þÎñÃû³ÆÁËÂð£¬Õâ²ÅÊÇÄãÒªµÄname
(2)Óà sc GetKeyName i Äã»áµÃµ½ÂúÒâµÄ½á¹û£¬¿´ÏÂÃæ¾ÍÖªµÀÁË¡£
[SC] GetServiceKeyName SUCCESS Name = you
(3)ÔÙÀ´ËµÒ»ÏµÚÈýÖÖ·½·¨£º
ÇëÓÃ wmic service where caption='i' get name
ÓеãÂý£¬¼¸Ãëºó£¬¾ÍÓÐÁËÏÂÃæµÄ½á¹û¡£
i
you
2.¼ÙÉèÃû³ÆÎªyou¡£ ÏÖÔÚ¿ÉÒÔÀ´É¾³ý·þÎñÁË¡£
Ò²ÓÐÈýÖְ취ɾ³ý¡£
(1)×Ҳ×îÓÐЧµÄ·½·¨ÊÇ´Ó×¢²á±íµÄHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ÕÒµ½ÄãÒªµÄÄǸö£¬¼´you¡£ ɾµôÕû¸öÏî¾Í¿ÉÒÔÁË£¬±ðɾ´íÁË£¬Òª²»È»¾ÍÖ»Óп޵ķÝÁË¡£
(2)sc delete you
(3)wmic service you delete
×¢Ò⣬ÓÃwmic ʱ£¬ÊÇ»áÓа²È«ÌáʾµÄ¡£
¿´£ºÉ¾³ý '\\PAN\ROOT\CIMV2:Win32_Service.Name="you"' Âð(Y/N/?)?ÕâÀïÊäÈëy
ɾ³ý·¶Àý \\PAN\ROOT\CIMV2:Win32_Service.Name="you"
·¶Àýɾ³ý³É¹¦¡£
ÖÁ´Ë´ó¹¦¸æ³ÉÁË¡£ÄãÔÙµ½services.msc¿´¿´£¬Ã»ÁËÄǸöÄÕÈ˵ÄiÁ˰ɡ£
×ܽ᣺
Ï൱ÓÚÊÇ·þÎñÃûÓÐcaptionºÍnameÖ®·Ö¡£
Àý×Ó£º
µÚÒ»²½£º
C:\>wmic service where caption='sDameWare Mini Remote Control' get name
Name
DWMRCS
µÚ¶þ²½£ºC:\>sc delete DWMRCS
[SC] DeleteService SUCCESS
Ïà¹ØÎĵµ£º
1.Ñ¡ÓÃÊʺϵÄOracleÓÅ»¯Æ÷
OracleµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ£º
a.RULE(»ùÓÚ¹æÔò)
b.COST(»ùÓڳɱ¾)
c.CHOOSE(Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷£¬¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊýµÄ
¸÷ÖÖÉùÃ÷£¬ÈçRULE¡¢COST¡¢CHOOSE¡¢ALL_ROWS¡¢FIRST_ROWS¡£Ä㵱ȻҲÔÚSQL¾ä¼¶»òÊǻỰ(session)¼¶¶ÔÆä½øÐи²
¸Ç¡£
ΪÁËʹÓûùÓڳɱ¾µÄÓÅ»¯Æ ......
¸ÅÊö
ÐéÄâרÓÃÊý¾Ý¿â (VPD) ÌṩÁ˽ÇÉ«ºÍÊÓͼÎÞ·¨ÌṩµÄÐм¶·ÃÎÊ¿ØÖÆ¡£¶ÔÓÚ»¥ÁªÍø·ÃÎÊ£¬ÐéÄâרÓÃÊý¾Ý¿â¿ÉÒÔÈ·±£ÔÚÏßÒøÐеĿͻ§Ö»ÄÜ¿´µ½ËûÃÇ×Ô¼ºµÄÕÊ»§¡£Web Íйܹ«Ë¾¿ÉÒÔÔÚͬһ Oracle Êý¾Ý¿âÖÐά»¤¶à¸ö¹«Ë¾µÄÊý¾Ý£¬µ«Ö»ÔÊÐíÿ¸ö¹«Ë¾²é¿´Æä×ÔÉíÊý¾Ý¡£
ÔÚÆóÒµÄÚ²¿£¬ÐéÄâÊý¾Ý¿â¿ÉÔÚÓ¦ÓóÌÐò²¿Êð·½Ãæ½µµÍÓµÓгɱ¾¡£¿ÉÒÔÔÚÊý ......
OracleÖпÉÒÔµ÷ÓÃJavaµÄ´úÂ룬һ°ãͨ¹ýÁ½ÖÖ·½Ê½½øÐе÷Óã¬Ò»¸öÊÇÖ±½Ó½«Java´úÂëдÔÚOracleÄÚ²¿£¬ÁíÍâÒ»ÖÖÊǽ«±àÒëºÃµÄclassÎļþÔØÈëµ½OracleÖС£
-A-
1¡¢ÔÚSQLPlusÖд´½¨OracleÖеÄJavaÀàÓë·½·¨£¨·½·¨±ØÐëÊǾ²Ì¬¹«Óз½·¨£©
create or replace and compile java source named hello as
public class Hello {
pu ......