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½çÓÖÊÇÒ»·¬·çÔƱä»ÃÁË¡£
Ïà¹ØÎĵµ£º
¿´À´ÓеÄÈË»¹ÊǶÔschemaµÄÕæÕýº¬Ò岻̫Àí½â£¬ÏÖÔÚÎÒÔÙ´ÎÕûÀíÁËһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵĶ¨Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in ......
ORACLE °²×°Ä¿Â¼½éÉÜ
ϵͳ»·¾³£º
1¡¢²Ù×÷ϵͳ£ºWindows 2000
2¡¢Êý¾Ý¿â£º¡¡Oracle 8i R2 (8.1.6) for NT ÆóÒµ°æ
3¡¢°²×°Â·¾¶£ºC:\ORACLE
½âÊÍ£º
Oracle 8i R2 (8.1.6) for NT ÆóÒµ°æĬÈÏ°²×°Íê±Ïºó»áÔÚËùÔÚÅÌ·û´´½¨ÒÔÏÂÈý¸öĿ¼
admin£º ¼Ç¼OracleʵÀýµÄÅäÖá¢ÔËÐÐÈÕÖ¾µÈÎļþ£¬Ã¿¸öʵÀýÒ»¸öĿ¼
Ora ......
¡¡¡¡Ò». ¸ÅÊö
¡¡¡¡Oracle´æ´¢¹ý³Ì¿ª·¢µÄÒªµãÊÇ£º
¡¡¡¡• ʹÓÃNotepadÎı¾±à¼Æ÷£¬ÓÃOracle PL/SQL±à³ÌÓïÑÔдһ¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐʹÓÃSQL*Plus¹¤¾ßÔËÐд洢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐÐ޸Ĵ洢¹ý³Ì;
¡¡¡¡• ͨ¹ý±àÒë´íÎóµ÷ÊÔ´æ´¢¹ ......
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æȨËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 19:31:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g E ......
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 ......