OracleÊÕ¹ºSunÈôʧ°Ü IBMÊÇ·ñÔÙÅ×éÏéÖ¦
¡¶¸£²¼Ë¹¡·ÍøÕ¾½üÈÕ·¢±íÎÄÕ³ƣ¬Èç¹û¼×¹ÇÎÄ74ÒÚÃÀÔªÊÕ¹ºSunµÄ¼Æ»®ÓÉÓÚÅ·Ã˵Ä×èÄÓ¶øÒÔʧ°Ü¸æÖÕ£¬Õâ²¢²»»á¸ø¼×¹ÇÎÄ´øÀ´Ì«´óËðʧ£¬µ«È´»áÁîSunÔâÊÜÖØ´´¡£
¼×¹ÇÎÄÊÕ¹ºSunµÄ½»Ò×ÈÔδ»ñµÃÅ·ÃËίԱ»áµÄÅú×¼¡£
Å·ÃË·´Â¢¶Ï¼à¹Ü²¿Ãŵ£ÐÄ£¬¼×¹ÇÎÄÊÕ¹ºSun½«¶ÔSunµÄ¿ªÔ´Êý¾Ý¿âÒµÎñMySQLÔì³É²»ÀûÓ°Ïì¡£¼×¹ÇÎÄÃæ¶ÔÅ·Ã˵ÄÒÉÂDz¢²»Ô¸×ö³öÈò½£¬¿ÉÄܻᵼÖÂÅ·ÃË·´¶ÔÕâÒ»½»Òס£
½ØÖÁĿǰ£¬¼×¹ÇÎÄÓëSunµÄ·¢ÑÔÈ˶¼¶Ô´ËδÖÿɷñ¡£´ËÇ°ÔøÓб¨µÀ³Æ£¬IBMÒÔ9.10ÃÀԪÿ¹ÉÊÕ¹ºSunµÄ½»Ò×Òѵ½ÁË×îºó½×¶Î£¬µ«ÓÉÓÚµ£ÐĽ»Ò×Òý·¢·´Â¢¶Ï¼à¹Ü²¿Ãŵĵ÷²é£¬ÒÔ¼°SunÏ£ÍûÒÔ¸ü¸ßµÄ¼Û¸ñ³öÊÛ¹«Ë¾£¬µ¼ÖÂIBM×îÖÕÀ뿪ÁËÕâÒ»½»Òס£µ«ÊÇÈç¹û×îÖÕ¼×¹ÇÎÄÊÕ¹ºSunʧ°ÜµÄ»°£¬Ãæ¶ÔÕâÑùÒ»¸ö¾ÖÃæIBM»á²»»áÖØÐÂÅ׳öéÏéÖ¦?Èç¹û´ËʱIBM½éÈëµÄ»°£¬²»½öÊÕ¹º³É±¾½øÒ»²½½µµÍ£¬¶øÇÒ»¹¶Ô¼×¹ÇÎÄÔì³É¸üÓÐÍþÉåÁ¦µÄ³å»÷¡£ÄÇÑùµÄ»°IT½çÓÖÊÇÒ»·¬·çÔÆ±ä»ÃÁË¡£
¼×¹ÇÎÄÊÕ¹ºSunµÄ½»Ò×ÈÔδ»ñµÃÅ·ÃËίԱ»áµÄÅú×¼¡£
Å·ÃË·´Â¢¶Ï¼à¹Ü²¿Ãŵ£ÐÄ£¬¼×¹ÇÎÄÊÕ¹ºSun½«¶ÔSunµÄ¿ªÔ´Êý¾Ý¿âÒµÎñMySQLÔì³É²»ÀûÓ°Ïì¡£¼×¹ÇÎÄÃæ¶ÔÅ·Ã˵ÄÒÉÂDz¢²»Ô¸×ö³öÈò½£¬¿ÉÄܻᵼÖÂÅ·ÃË·´¶ÔÕâÒ»½»Òס£
½ØÖÁĿǰ£¬¼×¹ÇÎÄÓëSunµÄ·¢ÑÔÈ˶¼¶Ô´ËδÖÿɷñ¡£´ËÇ°ÔøÓб¨µÀ³Æ£¬IBMÒÔ9.10ÃÀԪÿ¹ÉÊÕ¹ºSunµÄ½»Ò×Òѵ½ÁË×îºó½×¶Î£¬µ«ÓÉÓÚµ£ÐĽ»Ò×Òý·¢·´Â¢¶Ï¼à¹Ü²¿Ãŵĵ÷²é£¬ÒÔ¼°SunÏ£ÍûÒÔ¸ü¸ßµÄ¼Û¸ñ³öÊÛ¹«Ë¾£¬µ¼ÖÂIBM×îÖÕÀ뿪ÁËÕâÒ»½»Òס£µ«ÊÇÈç¹û×îÖÕ¼×¹ÇÎÄÊÕ¹ºSunʧ°ÜµÄ»°£¬Ãæ¶ÔÕâÑùÒ»¸ö¾ÖÃæIBM»á²»»áÖØÐÂÅ׳öéÏéÖ¦?Èç¹û´ËʱIBM½éÈëµÄ»°£¬²»½öÊÕ¹º³É±¾½øÒ»²½½µµÍ£¬¶øÇÒ»¹¶Ô¼×¹ÇÎÄÔì³É¸üÓÐÍþÉåÁ¦µÄ³å»÷¡£ÄÇÑùµÄ»°IT½çÓÖÊÇÒ»·¬·çÔÆ±ä»ÃÁË¡£
Ïà¹ØÎĵµ£º
ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ
×÷Õߣº[תÌù] ³ö´¦£º
×î
½ü×öÒ»¸öJ2EEÏîÄ¿£¬ÐèÒªÔÚJSPÒ³ÃæÊµÏÖ¶ÔÎļþµÄÉÏ´«ºÍÏÂÔØ¡£ºÜÔçÒÔǰ¾ÍÖªµÀJDBCÖ§³Ö´ó¶ÔÏó£¨LOB£©µÄ´æÈ¡£¬ÒÔΪºÜÈÝÒ×£¬×öÆðÀ´²Å·¢ÏÖÎÊÌâ¶à
¶à£¬¶ÁÁËÒ»´ó¶ÑÎÄÕ£¬·´¶øÃ»ÓÐʲôͷÐ÷ÁË¡£ÕýÈçÒ»Î»ÍøÓÑÎÄÕÂËù½²£º“&h ......
ǰÑÔ£º
sql_trace ÊÇÎÒÔÚ¹¤×÷Öо³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
ÒòΪÊý¾Ý¿âÂýÔÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾³£»áÓõ½µÄ¹¤¾ß ......
¡¡¡¡Ò». ¸ÅÊö
¡¡¡¡Oracle´æ´¢¹ý³Ì¿ª·¢µÄÒªµãÊÇ£º
¡¡¡¡• ʹÓÃNotepadÎı¾±à¼Æ÷£¬ÓÃOracle PL/SQL±à³ÌÓïÑÔдһ¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐʹÓÃSQL*Plus¹¤¾ßÔËÐд洢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐÐ޸Ĵ洢¹ý³Ì;
¡¡¡¡• ͨ¹ý±àÒë´íÎóµ÷ÊÔ´æ´¢¹ ......
ÒÔǰ·¢¹ýÒ»ÆªÒÆ¶¯Êý¾ÝÎļþµÄ·½·¨µÄÎÄÕ£¬²Î¼û
http://blog.csdn.net/wh62592855/archive/2009/11/20/4843764.aspx
²»¹ýµ±Ê±Ö»¸ø³öÁËÒ»¸öʾÀý¶øÒÑ£¬½ñÌìÔÚÊéÖп´µ½ÁËÁíÒ»ÖÖ·½·¨£¬×ܽáһϣ¬¼ÇÔÚÕâÀï¡£
OracleÌṩÁËÁ½ÌõÒÆ¶¯Êý¾ÝÎļþµÄÓï¾ä
1
ALTER TABLESPACE ±í¿Õ¼äÃû
RENAME DATAFILE 'ÎļþÃû' [,'ÎļþÃû']...
TO ' ......
ORA-00604 error occurred at recursive SQL level string
Cause:An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
Action:If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Custome ......