ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîȨÍþµÄרҵ¼¼Êõ±ê×¼ËüÊÇרΪÈÏÖ¤ÄÇЩÄܹ»Âú×ã¶ÔOracleºËÐIJúÆ·µÄ·þÎñÓëÖ§³Ö²¢¾ßÓÐæµÊìµÄ²Ù×÷ÄÜÁ¦Óë¹ã·ºÀíÂÛ֪ʶµÄרҵÈËÊ¿¡£Oracle ÈÏ֤Ŀǰ·ÖΪÈý¸ö²ã´ÎOCA¡¢OCP¡¢OCM¡£¼´Oracle Certified Professi£¨Ö»ÓÐOracle9iÓд˼¶ÈÏÖ¤£©£¬OCP¼´£¬Oracle Certified Professi£¬OCM¼´Oracle Certified Master¡£ÆäÖÐOCP°üÀ¨ÁËÊý¾Ý¿â¹ÜÀí·½ÏòµÄDBA¡¢Êý¾Ý¿â¿ª·¢·½ÏòµÄDEV¼°OracleÓ¦ÓòúÆ··½ÏòµÄApplicationsר¼Ò¡£
2¡¢ÎÊ£ºOracle ÈÏÖ¤¶ÔÎÒ¸öÈ˵ÄÒâÒåºÎÔÚ£¿
´ð£ºÒâÒåÖØ´ó¡£»ñµÃÓëÖ°ÎñÏà¹ØµÄÈÏÖ¤£¬Ö¤Ã÷ÄúÊÇÒ»¸öºÏ¸ñµÄ¼¼ÊõÈËÔ±¡£ ×÷ΪOracle ÈÏ֤ר¼Ò£¬Äú½«¾ßÓжÔÒµ½ç×î¾ßÌôÕ½ÐԵĻúÓö¸üÉîµÄ¶´²ìÁ¦ ²¢»ñÈ¡¸ü¶àµÄÊÕ»ñ ÐÅÏ¢¼¼ÊõÁìÓòÐèÒª´óÁ¿×¨¼Ò£¬Í¬Ê±¹¤×÷¾ºÕùÒ²Òì³£¼¤ÁÒ£¬ ²»ÂÛ¶ÔÓÚÐÂÊÖ»¹ÊÇÓоÑéµÄר¼Ò¶¼ÐèÒªÕÆÎÕÓÃÈ˵¥Î»¸ÐÐËȤµÄ¼¼Êõ¡£ÓÃÈ˵¥Î»Ñ°ÕÒ¸÷ÖÖ·½Ê½À´Çø·ÖÔ±¹¤ºÍDZÔÚÔ±¹¤ÒªÇóÔ±¹¤±ØÐë¾ß±¸ÎªÓÐЧ¹¤×÷ËùÐèµÄ¼áʵµÄ¼¼Êõ»ù´¡¡£
3¡¢ÎÊ£ºÔõÑù²ÅÄÜ»ñµÃOracle ÈÏÖ¤£¿
¡¡´ð£ºÄúÐèÒª°´ÕÕÄúµÄÖ°Òµ·¢Õ¹·½Ïò£¬²Î¼ÓÅàѵ²¢Í¨¹ýÏàÓ¦µÄOracle¹ú¼ÊÈÏÖ¤¡£
4¡¢ÎÊ£ºÎÒÏ뿼Oracle ÈÏÖ¤£¬ÇëÎʿɲ»¿ÉÒÔÖ±½Ó²Î¼Ó¿¼ÊÔ£¿
´ð£º´Ó2002Äê9ÔÂ1ÈÕÆðOracle¹«Ë¾¿ªÊ¼Ö´ÐÐеÄÈÏÖ¤¹æ¶¨£ºÖ±½Ó²Î¼Ó¿¼ÊÔÄú½«²»ÄÜ»ñµÃ Oracle ÈÏÖ¤¡£Ò²¾ÍÊÇ˵£¬ÄúÈç¹ûÏë»ñµÃOracle¾Í±ØÐë²Î¼ÓOracleÊÚȨ½ÌÓýÖÐÐĵÄÅàѵ£¬Õâ¾ÍÒâζ×ÅÖ»ÓвμÓÁËOracleÕý¹æÑϸñÅàѵµÄÈË£¬²ÅÓÐ×ʸñ»ñµÃOracleר¼ÒÈÏÖ¤£¬Õâ¾Í±£Ö¤ÁËOracle ÈÏÖ¤µÄº¬½ðÁ¿£¬Ò²ÊǶÔOracle ÈÏ֤ר¼ÒµÄ±£»¤¡£
5¡¢ÎÊ£ºOracle 9i²úÆ·µÄ¶¨Î»¼°¹¦ÄÜÊÇʲô£¿
¡¡´ð£ºOracle 9iÊý¾Ý¿âÊÇOracle¹«Ë¾ÍƳöµÄ×îÐÂÒ»´úÊý¾Ý¿â£¬ÓëOracle 8iÏà±ÈÔö¼ÓÁËÉϰÙÖÖÐÂÌØÐÔ£¬ÆäÖÐ×îÍ»³öµÄÊǾ¼ÃÐÔ¡¢¸ß¿ÉÉìËõÐԺ͸߿ÉÓÃÐÔÒÔ¼°ÍêÉÆµÄ¹¦ÄÜ¡£Oracle 9i²ÉÓÃÁËReal Application Clusters¼¼Êõ£¬ÎªÓû§ÌṩÁËÎÞÏ޵ĿÉÉìËõÐÔºÍ×
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';
±¾°¸Àý¾ßÌå´´½¨ÈçÏÂ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬¾ßÌåÓï·¨ÈçÏ ......
Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
°²×° Tomcat5.0 ǰÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server ......
ÎÊÌâÃèÊö
1¡¢Ó¦ÓÃÁ¬½ÓÊý¾ÝÒì³£»ºÂý£¬°üÀ¨¿Í»§¶ËʹÓÃplsqlÁ¬½Ó£»
2¡¢Êý¾Ý¿âÖ÷»úcpuÕ¼ÓÃÂʾӸ߲»Ï£¬IOдÈë¾Ó¸ß²»Ï¡£
3¡¢Ö÷»úÈÕ³£Î¬»¤²Ù×÷ÏìÓ¦Âý£¬Èçman»òw£»
·ÖÎöÎÊÌâ
ØÏµÍ³¼°oracleÓ¦ÓÃΪʲôÏìÓ¦Âý
1¡¢ÎªÊ²Ã´ÏµÍ³Á¬wÕâô¼òµ¥µÄ²Ù×÷¶¼»á¾õµÃ¿¨ÄØ£¿
2¡¢ÎªÊ²Ã´Ã»ÓÐÈκÎÓ¦ÓýÓÈëµÄÇé¿öÏ£¬Êý¾Ý¿â»áÓдóÁ¿µÄдÈë ......