oracleÓëmysqlµÄÇø±ð
ËÓÐoracleÓëmysql µÄÇø±ð×ÊÁÏ
Ê²Ã´Çø±ð?
Óï·¨?
¹æÄ£?
Ó¦Óò¿Êð?
½á¹¹?
......ÄãÕâ¸ö·¶Î§Ò²Ì«´óÁ˰É
¾ÍÊÇOracleÖÐÓеĺ¯Êý£¬¶øÔÚmysqlÖÐûÓУ¬Ò²²»ÄÜÓõİ¡
ËûÃÇÖ®¼ä±ê×¼SQL99¶¼Ö§³ÖµÄ,ORACLE×Ô¼ºµÄPL/SQLÊÇÔÚSQLÉÏ×öÀ©Õ¹,
ºÜ¶àº¯ÊýûÓÐ,ûÓÐ×ö¹ý×ܽᰡ,ÀýÈçWM_CONCAT(),ROW_NUMBER(),DUMP()¶àÁËÈ¥ÁË,µÈ......
ѧϰһÏÂ
http://blog.csdn.net/shiyuntian_wang/archive/2009/10/14/4671813.aspx
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......