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 ¡¡ ÇóÏê½â
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21 SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......