oracleÿÌìÌض¨Ê±¼ä×Ô¶¯ÖØÆô - Oracle / »ù´¡ºÍ¹ÜÀí
¹«Ë¾oracle²»ÖªµÀΪʲô£¬Ã¿ÌìÉÏÎçʮһµã×Ô¶¯ÖØÆô£¬×¼Ê±µÄ£¬Í¦·³ÈË¡£¿´ÈÎÎñ¼Æ»®Îª¿Õ£¬¿´oracleÈÕÖ¾£¬ÓüÇʱ¾´ò¿ªÊÇÂÒÂ룬²»ÖªµÀÔõôȷ¶¨ÎÊÌ⣬Ӧ¸Ã´ÓÄÄÀïÈëÊÖ£¬Ð»Ð»¡£
up! ¿´Ò»ÏÂalert log ÈÕÖ¾ÀïÓÐʲôÐÅÏ¢¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977ÒýÓà ¿´Ò»ÏÂalert log ÈÕÖ¾ÀïÓÐʲôÐÅÏ¢¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net ¡¡ ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ¿´·þÎñÆ÷µÄϵͳÈÕÖ¾£¬»òÕ߶¨Ê±¼Æ»®ÈÎÎñÒýÓà ¿´·þÎñÆ÷µÄϵͳÈÕÖ¾£¬»òÕ߶¨Ê±¼Æ»®ÈÎÎñ ¼Æ»®ÈÎÎñΪ¿Õ¡£ ϵͳÈÕÖ¾ÏÔʾûÓÐÎÊÌâ¡£ÒýÓà ¿´Ò»ÏÂalert log ÈÕÖ¾ÀïÓÐʲôÐÅÏ¢¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net ¡¡ ÇóÏê½â
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......