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

OracleÅàѵ֮Âà ÉÇÍ·

Õâ´ÎÈ¥ÉÇÍ·ÊǸøÉÇÍ·µçÐŽ²¿Î,Ö÷½²ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯,ΪÆÚ4Ìì.´ÓÂÞºþÆû³µÕ¾³ö·¢,×ßÉîÉǸßËÙ,´óÔ¼4,5¸öÖӾ͵½ÉÇÍ·ÁË.
³ö·¢Ê±ÊÇ°øÍí,³µ×ÓÔÚÉîÉǸßËÙÐнø,ϦÑôÎ÷Ï£¬ÂäÈÕµÄÓà»ÔÕÕÓ³ÔÚ¹«Â·Á½±ßµÄÇðÁê,ɽÌÁÉÏ£¬¿´ÉÏÈ¥ºÜÃÀ¡£ÉîÉǸßËٴ󲿷ÖÊÇÑØן£°¶ÏßòêÑÑ£¬ËùÒÔ£¬ÓÐʱÔÚ³µÉϾÍÄܹ»¿´µ½º££¬ÂäÈÕµÄÓà»ÔÕÕÔÚ´óº£ÉÏ£¬²¨¹âÁÛÁÛ£¬¼ÓÖ®º£·çÏ°Ï°£¬ÊÇÎÒϲ»¶µÄÄÇÖָоõ¡£ÎÒûÓÐÐÄ˼¹Û¿´³µÉϵĵçÓ°£¬´ó²¿·Öʱ¼äÎÒ¶¼ÊÇ´ò¿ª³µ´°£¬±¥ÀÀº£°¶·ç¹â¡£¹«Â·Á½±ßºÜ¶àСɽ£¬²»¸ß£¬µ«¿´ÉÏÈ¥ºÜºÃÍ棬ºÃ±È¼ÒÏçºóÃæµÄСɽ£¬Ð¡µÄʱºòÎÒÃǾ­³£ÅÀÉÏÈ¥Í棬»òÔÚɽÆÂÀïÍæÈüÅÜ£¬¿´Ë­µÚÒ»¸ö´ÓɽÏÂÅܵ½É½¶¥£¬´Óɽ¶¥Åܵ½É½ÎÑ¡£Í¯ÄêµÄ»¶ÀÖÏÖÔÚºÜÄÑÖØÊ°£¬ÎÒÖ»ÄÜÒÐ×ųµ´°£¬³Á½ûÔÚͯÄ껶ÀֵĻØÒäÖС£
½øÈëÉÇÍ·ÊÐÇø£¬Ó­ÃæÒ²ÊÇÒ»×ùбÀ­Ë÷´óÇÅ£¬ÉÇÍ·µçÐŵÄÖì¿¡·åÖ÷ÈÎÔÚ³µÕ¾µÈºò¶àʱ£¬Ê±¼äÒÑÊÇÍíÉÏ9µã¶àÁË£¬ÎÒÃÇÔÚÒ»¼Ò²ÍÌü³ÔÍê·¹£¬ÖìÖ÷ÈξͿª³µËÍÎÒµ½Áúºþ±ö¹Ý¡£
   ÉÇÍ·µçÐŵÄÅóÓÑ£¬²Î¼Ó´Ë´ÎÅàѵµÄ¶¼±È½ÏÄêÇᣬ¹À¼ÆºÜ¶à´Ó´óѧ±ÏÒµ³öÀ´Ã»¶à¾Ã£¬ËùÒÔÎÊÌâÒ²ÌرðµÄ¶à£¬¿ÎÌÃÆø·ÕÈÈÁÒ£¬ÓÐʱ²îµãû°ÑÎÒ¸ãÃÉ¡£ºÇºÇ£¬ÄêÇáÈË×ÜÊǺÜÓм¤Ç飬¼ÇµÃÔÚ½²ORACLE SQLÓÅ»¯Ê±£¬ºÜ¶àѧԱֱ½Ó½«ËûÃÇƽʱ¾õµÃºÜÂýµÄÎÊÌâSQL·¢¸øÎÒ£¬ÈÃÎÒÇÐÇÐʵʵµØÌå»áµ½ÁËÏÖ³¡×öÓÅ»¯µÄ¹¤×÷Æø·Õ¡£¿É±ðС¿´ÕâЩÄêÇáС»ï×Ó°¡£¬ËûÃǸø³öµÄÎÊÌâÄѶȶ¼²»Ð¡ÍÛ£¬¸Õ´ÓѧУ³öÀ´£¬»¹´ø×ÅÄǹɴòÆÆɳ¹øÎʵ½µ×µÄѧϰ¾¢¶ù¡£ºÇºÇ£¬²»¹ý£¬ËûÃÇÒ²ÓÐһЩ±¦¹óµÄÍæÒâ¶ù£¬ÓÐÒ»¿î¿ÉÒÔÔÚ¾ÖÓòÍøÄÚ·Ö·¢ÎļþµÄÈí¼þ£¬½Ð“·É¸ë´«Ê锣¬ÒÔ¼°Ò»¿î¿ÉÒÔ´Ó¸÷¸öÖն˿´µ½ÀÏʦµÄµçÄÔÆÁÄ»µÄ½ÌѧÈí¼þ£º“HtScreen”,ÎÒ¾õµÃ¾ÍÌرðµÄºÃ£¬ÎÒÌØÒ⿽ÏÂÀ´ÁË£¬ËäÈ»ÊǵÁ°æ£¬µ«ÎÒ¾ö¶¨ÔÚÎÒÒÔºóµÄ¿ÎÌÃÉϲÉÓÃÕâ¿îÈí¼þ(ÎÒ֮ǰ²ÉÓÃNetMeeting£¬µ«Î¢ÈíµÄÕâ¸ö¶«¶«ÔÚÁ¬½ÓÓû§¶àÁ˵ÄÇé¿öÏ£¬²Ù×÷ÌرðµØÂý£¬ÐÔÄܲ»ºÃ¡£¶øHtScreenÔòÊÇÇáÁ¿¼¶µÄ£¬ËüÏ൱ÓÚ½«ÀÏʦµÄÖն˹㲥³öÈ¥£¬¼´Ê¹50¸öѧԱÁ¬½ÓÉÏÄãµÄµçÄÔ£¬Ò²¸Ð¾õ²»µ½±äÂý).
   ×ÜÌåÀ´½²£¬Õâ´ÎµÄÅàѵʵսЧ¹ûÊÇ×îºÃµÄ£¡Ð¡»ï×ÓÃÇѧµÃÆð¾¢£¬Ïû»¯ÎüÊÕÒ²¿ì¡£µçÐŵÄÖìÖ÷ÈÎÓÐÒâ½øÐеÚ2´ÎÕâÑùµÄÅàѵ¡£
ƽ³£ÎÒÊÇÔÚÁúºþ±ö¹Ý³Ô·¹£¬¾ÆµêµÄ¸÷ÖÖ¸÷ÑùµÄµãÐĵ¹Ê±ºÜ¶à£¬Ê²Ã´Óã½Èѽ£¬ÓãÍèѽ£¬Å£ÈâÍèѽ£¬³¦·ÛµÈµÈ£¬¾Ý˵¶¼ÊÇÉÇÍ·µÄÌØɫС³Ô£¬¿ÉÊÇûÓÐÀ±Î¶£¬ºÜÓе㲻ºÏÎҵĿÚζ¡£ÓÚÊÇÍí²ÍÒ»°ãÊÇÖìÖ÷ÈνÓÎÒµ½ÍâÃæ³Ô¡£ÎÒÃÇ¿ª³µµ½º£±õ·£¬´ó¸Åÿ¸ö±õº£µÄ³ÇÊж¼»áÓйۺ£³¤ÀÈ°É£¬ÉÇÍ·Ò²²»ÀýÍâ¡£ÎÒÃÇÑ¡ÁËÒ»¼Ò¿¿º£±ßµÄ²ÍÌü£¬ÔÚ¶þÂ¥£¬»ù


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

oracleÔÚlinuxÏÂÆô¶¯Ïà¹ØÃüÁî

1¡¢´ÓrootÓû§Çл»µ½oracleÓû§
#su - oracle
2¡¢ÀûÓÃnologÑ¡ÏîÆô¶¯sql*plus¹¤¾ß³ÌÐò
$slqplus /nolog
3¡¢ÀûÓÃsysdbaÉí·ÝÆô¶¯oracleÊý¾Ý¿â
sql>connect / as sysdba
sql>startup
4¡¢Æô¶¯Êý¾Ý¿âµÄ¼àÌýÆ÷listener
$lsnrctl start
»ò
$lsnrctl
lsnrctl>start
5¡¢¹Ø±ÕoracleÊý¾Ý¿â¼àÌý
$lsnrctl stop
6¡ ......

OracleÓû§È¨ÏÞ¿ØÖÆ

1£©¡¢¹¹ÔìʵÀý£º
ÎÒÃÇÒѾ­´´½¨ºÃÊý¾Ý¿âÓû§test_user£¬Ï±ߴæÔÚtest_table±íºÍtest_procedure´æ´¢¹ý³Ì¡£ÎÒÃÇÒѾ­´´½¨ºÃÒ»¸ö¿ÕµÄ´úÀíÊý¾Ý¿âÓû§agent_user¡£
2£©¡¢µÇ¼test_userÓû§£¬½«test_userϱíµÄselectȨÏ޺ʹ洢¹ý³ÌµÄexcuteȨÏÞ¸³¸ø´úÀíÓû§agent_user¡£
SQL>GRANT select ON test_table TO agent_user;
SQL ......

ORACLE LOB×ֶΠ²»ÄÜÓÃunion ²éѯ

lob×ֶβ»ÄÜ×ögroup   by£¬¶øunionÖÐÐèҪʹÓÃgroup   by¹ýÂ˵ôÖظ´¼Í¼£¬ËùÒÔ²»ÐР¡£ ÓÃunion  all¾Í¿ÉÒÔÁË¡£
Áí£ºunion ºÍ union allÇø±ð£º
       UNIONÔÚ½øÐбíÁ´½Óºó»áɸѡµôÖظ´µÄ¼Ç¼£¬ËùÒÔÔÚ±íÁ´½Óºó»á¶ÔËù²úÉúµÄ½á¹û¼¯½øÐÐÅÅÐòÔËË㣬ɾ³ýÖظ´µÄ¼Ç¼ÔÙ·µ» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ