½ñÌìÓöµ½Ò»¸öÆæ¹ÖµÄÎÊÌ⣬OralceÊý¾Ý¿â£¬Öظ´»ñÈ¡jdbcÁ¬½Ó¡¢ÔÙÁ¢¿Ì¹Ø±Õ£¬Ñ»·200´Î×óÓÒ£¬¼´Å׳öÒì³£:
Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descrip ......
±íÊý¾Ý±È½Ï´ó£¬×öÒ»¸ödelete²Ù×÷£ºdelete from mac_ppre_asset_bill_a where bill_month ='200911'
ToadÓÐûÓÐÀïÓÐûÓÐÕâÑùµÄ¹¦ÄÜ£¬
Unix·þÎñÆ÷£¬
ϰàÒª»Ø¼ÒÁË£¬ÈÃËû×Ô¼ºÅÜ¡£¡£¡£¡£
Çë˵µÄ¾ßÌåÒ»µã лл
¿ÉÒÔÓÃSecureCRTµÇ¼unix·þÎñÆ÷£¬ÔÚ·þÎñÆ÷ÀïÃæÁ¬½Ó½øÈ¥£¬Óúǫ́·½Ê½½ø³ÌÁ¬½Ósqlplus²¢Ö´ÐÐsql,È ......
¸÷λ´óÏÀÃÇ£¬Ð¡µÜÎÒJAVAÓóÌÐòÁ¬½ÓoracleÊý¾Ý¿âµÃµ½Á¬½ÓûÎÊÌ⣬ÎÒ°ÑËû·ÅÔÚInstall4jµÄ°²×°¹ý³ÌÖоÍÓÐÎÊÌâÁË £¬ÔÚ°²×°¹ý³ÌÖÐÈç¹ûÎÒÑ¡ÔñÁËORACLEÊý¾Ý¿âÁ¬½Ó£¬ÅäÖúòÎÊýºó±¨Õâ¸ö´í
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value spe ......
Õ÷¼¯´ó¼ÒÒâ¼û£º
OracleÈÏÖ¤ÔõôÑù£¿Ë¼¿ÆÈÏ֤Ĩ£¿
¿ÉÒÔ̸̸×Ô¼ºµÄÏë·¨Âð£¿
²»Í¬ÁìÓòµÄÈÏÖ¤,ûÓÐʲô¿É±ÈÐÔ
ÎÒÒ²ÏëÖªµÀOracleÈÏÖ¤ÔõôÑù£¿
ÒýÓÃ
Õ÷¼¯´ó¼ÒÒâ¼û£º
OracleÈÏÖ¤ÔõôÑù£¿Ë¼¿ÆÈÏ֤Ĩ£¿
¿ÉÒÔ̸̸×Ô¼ºµÄÏë·¨Âð£¿
²»Í¬ÁìÓò£¬Ã»ÓпɱÈÐÔ£¬µ«ÊÇÓÐÒ»µã£¬ÏÖÔÚ¶þÕßµÄÈÏÖ¤¶¼Ã»ÓÐÔÀ´µÄº¬ ......
Á´½Óµ½Í¬Ò»¸öÊý¾Ý¿â£¬ÎªÊ²Ã´²»Í¬Óû§¿´µ½µÄ±í²»Ò»Ñù£¿
ÔÚÓû§user1Ï´´½¨±íTable1£¬ÎªÊ²Ã´ÔÚÓû§user2Ï¿´²»µ½Table£¿
OracleϵÄÓû§µ½µ×ÊǸöʲô¸ÅÄî°¡£¿
ÒÔǰÊÇÓÃSQL ServerµÄ£¬ËùÓеÄÓû§£¬Ö»ÒªÁ´½Óµ½Í¬Ò»¸öÊý¾Ý¿â£¬¿´µ½µÄÊý¾Ý¿â¶ÔÏó¶¼ÊÇÒ»ÑùµÄ°¡¡£
¾´ÇëÏê½â¡£
oracleÊÇÒ»¸ö¶àÓû§µÄ²Ù×÷Ï ......
ÈçÌ⣺sqlµ÷Õû×î¹Ø×¢µÄÊÇʲô£¿
µ±ÃæÊÔ¹ÙÕâÑùÎÊÎÒʱ£¬ÎÒÔõô»Ø´ð²Å¹»×¨Òµ£¿£¿£¿£¿Ï£ÍûµÃµ½×¨Òµ¡¢ÕýÈ·µÄ»Ø´ð£¡£¡
ÐÔÄÜ£¿Ï¹²Â£¬ºÇºÇ¡£
¹Ø×¢Ö´Ðмƻ® ,±ØÐë×ßindex seekµÄʱºò¾ø²»×ßscan, ˵µ½µ×ÁË ¾ÍÊÇÓÃ×îÉÙµÄ×ÊÔ´×ö×î¶àµÄÊÂ,
²¢ÇÒ°ÑÓ¦Óõĵ±Ç°»·¾³¿¼ÂǽøÀ´,Æ©Èç~ lockÁ£¶ÈµÄÑ¡Ôñ...²¢·¢µÄÁ¿ ,tableµÄÉè¼Æ..
......