OracleÅàѵ֮Âà ÉÇÍ·
Õâ´ÎÈ¥ÉÇÍ·ÊǸøÉÇÍ·µçÐŽ²¿Î,Ö÷½²ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯,ΪÆÚ4Ìì.´ÓÂÞºþÆû³µÕ¾³ö·¢,×ßÉîÉǸßËÙ,´óÔ¼4,5¸öÖӾ͵½ÉÇÍ·ÁË.
³ö·¢Ê±ÊÇ°øÍí,³µ×ÓÔÚÉîÉǸßËÙÐнø,ϦÑôÎ÷Ï£¬ÂäÈÕµÄÓà»ÔÕÕÓ³ÔÚ¹«Â·Á½±ßµÄÇðÁê,ɽÌÁÉÏ£¬¿´ÉÏÈ¥ºÜÃÀ¡£ÉîÉǸßËٴ󲿷ÖÊÇÑØן£°¶ÏßòêÑÑ£¬ËùÒÔ£¬ÓÐʱÔÚ³µÉϾÍÄܹ»¿´µ½º££¬ÂäÈÕµÄÓà»ÔÕÕÔÚ´óº£ÉÏ£¬²¨¹âÁÛÁÛ£¬¼ÓÖ®º£·çÏ°Ï°£¬ÊÇÎÒϲ»¶µÄÄÇÖָоõ¡£ÎÒûÓÐÐÄ˼¹Û¿´³µÉϵĵçÓ°£¬´ó²¿·Öʱ¼äÎÒ¶¼ÊÇ´ò¿ª³µ´°£¬±¥ÀÀº£°¶·ç¹â¡£¹«Â·Á½±ßºÜ¶àСɽ£¬²»¸ß£¬µ«¿´ÉÏÈ¥ºÜºÃÍ棬ºÃ±È¼ÒÏçºóÃæµÄСɽ£¬Ð¡µÄʱºòÎÒÃǾ³£ÅÀÉÏÈ¥Í棬»òÔÚɽÆÂÀïÍæÈüÅÜ£¬¿´ËµÚÒ»¸ö´ÓɽÏÂÅܵ½É½¶¥£¬´Óɽ¶¥Åܵ½É½ÎÑ¡£Í¯ÄêµÄ»¶ÀÖÏÖÔÚºÜÄÑÖØÊ°£¬ÎÒÖ»ÄÜÒÐ×ųµ´°£¬³Á½ûÔÚͯÄ껶ÀֵĻØÒäÖС£
½øÈëÉÇÍ·ÊÐÇø£¬ÓÃæÒ²ÊÇÒ»×ùбÀË÷´óÇÅ£¬ÉÇÍ·µçÐŵÄÖì¿¡·åÖ÷ÈÎÔÚ³µÕ¾µÈºò¶àʱ£¬Ê±¼äÒÑÊÇÍíÉÏ9µã¶àÁË£¬ÎÒÃÇÔÚÒ»¼Ò²ÍÌü³ÔÍê·¹£¬ÖìÖ÷ÈξͿª³µËÍÎÒµ½Áúºþ±ö¹Ý¡£
ÉÇÍ·µçÐŵÄÅóÓÑ£¬²Î¼Ó´Ë´ÎÅàѵµÄ¶¼±È½ÏÄêÇᣬ¹À¼ÆºÜ¶à´Ó´óѧ±ÏÒµ³öÀ´Ã»¶à¾Ã£¬ËùÒÔÎÊÌâÒ²ÌرðµÄ¶à£¬¿ÎÌÃÆø·ÕÈÈÁÒ£¬ÓÐʱ²îµãû°ÑÎÒ¸ãÃÉ¡£ºÇºÇ£¬ÄêÇáÈË×ÜÊǺÜÓм¤Ç飬¼ÇµÃÔÚ½²ORACLE SQLÓÅ»¯Ê±£¬ºÜ¶àѧԱֱ½Ó½«ËûÃÇƽʱ¾õµÃºÜÂýµÄÎÊÌâSQL·¢¸øÎÒ£¬ÈÃÎÒÇÐÇÐʵʵµØÌå»áµ½ÁËÏÖ³¡×öÓÅ»¯µÄ¹¤×÷Æø·Õ¡£¿É±ðС¿´ÕâЩÄêÇáС»ï×Ó°¡£¬ËûÃǸø³öµÄÎÊÌâÄѶȶ¼²»Ð¡ÍÛ£¬¸Õ´ÓѧУ³öÀ´£¬»¹´ø×ÅÄǹɴòÆÆɳ¹øÎʵ½µ×µÄѧϰ¾¢¶ù¡£ºÇºÇ£¬²»¹ý£¬ËûÃÇÒ²ÓÐһЩ±¦¹óµÄÍæÒâ¶ù£¬ÓÐÒ»¿î¿ÉÒÔÔÚ¾ÖÓòÍøÄÚ·Ö·¢ÎļþµÄÈí¼þ£¬½Ð“·É¸ë´«Ê锣¬ÒÔ¼°Ò»¿î¿ÉÒÔ´Ó¸÷¸öÖն˿´µ½ÀÏʦµÄµçÄÔÆÁÄ»µÄ½ÌѧÈí¼þ£º“HtScreen”,ÎÒ¾õµÃ¾ÍÌرðµÄºÃ£¬ÎÒÌØÒ⿽ÏÂÀ´ÁË£¬ËäÈ»ÊǵÁ°æ£¬µ«ÎÒ¾ö¶¨ÔÚÎÒÒÔºóµÄ¿ÎÌÃÉϲÉÓÃÕâ¿îÈí¼þ(ÎÒ֮ǰ²ÉÓÃNetMeeting£¬µ«Î¢ÈíµÄÕâ¸ö¶«¶«ÔÚÁ¬½ÓÓû§¶àÁ˵ÄÇé¿öÏ£¬²Ù×÷ÌرðµØÂý£¬ÐÔÄܲ»ºÃ¡£¶øHtScreenÔòÊÇÇáÁ¿¼¶µÄ£¬ËüÏ൱ÓÚ½«ÀÏʦµÄÖն˹㲥³öÈ¥£¬¼´Ê¹50¸öѧԱÁ¬½ÓÉÏÄãµÄµçÄÔ£¬Ò²¸Ð¾õ²»µ½±äÂý).
×ÜÌåÀ´½²£¬Õâ´ÎµÄÅàѵʵսЧ¹ûÊÇ×îºÃµÄ£¡Ð¡»ï×ÓÃÇѧµÃÆð¾¢£¬Ïû»¯ÎüÊÕÒ²¿ì¡£µçÐŵÄÖìÖ÷ÈÎÓÐÒâ½øÐеÚ2´ÎÕâÑùµÄÅàѵ¡£
ƽ³£ÎÒÊÇÔÚÁúºþ±ö¹Ý³Ô·¹£¬¾ÆµêµÄ¸÷ÖÖ¸÷ÑùµÄµãÐĵ¹Ê±ºÜ¶à£¬Ê²Ã´Óã½Èѽ£¬ÓãÍèѽ£¬Å£ÈâÍèѽ£¬³¦·ÛµÈµÈ£¬¾Ý˵¶¼ÊÇÉÇÍ·µÄÌØɫС³Ô£¬¿ÉÊÇûÓÐÀ±Î¶£¬ºÜÓе㲻ºÏÎҵĿÚζ¡£ÓÚÊÇÍí²ÍÒ»°ãÊÇÖìÖ÷ÈνÓÎÒµ½ÍâÃæ³Ô¡£ÎÒÃÇ¿ª³µµ½º£±õ·£¬´ó¸Åÿ¸ö±õº£µÄ³ÇÊж¼»áÓйۺ£³¤ÀÈ°É£¬ÉÇÍ·Ò²²»ÀýÍâ¡£ÎÒÃÇÑ¡ÁËÒ»¼Ò¿¿º£±ßµÄ²ÍÌü£¬ÔÚ¶þÂ¥£¬»ù
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
Õâ´ÎÊÇÓ¦ÀèÃ÷ÍøÂçµÄÑûÇ룬ȥÉîÛڱ߷À¼ì²éÖ¸»ÓÖÐÐĽøÐÐORACLEµÄÅàѵ¡£Åàѵ·Ö¶þÆÚ£¬Ã¿ÆÚ4Ì죬ÅÅÔÚAIXµÄÅàѵ֮ºó¡£
ÉϿεĵصã¾ÍÔÚÂÞºþ¿Ú°¶£¬Ñ§Ô±À´×Ô¸÷¸ö·ÖÕ¾£ºÉîÛÚÍ壬»Ê¸Ú¿Ú°¶£¬ÂÞºþ¿Ú°¶£¬×ÜÖ¸»ÓÖÐÐÄ£¬Ð¡Ã·É³£¬ÉõÖÁ»¹ÓÐÉÇÍ·ºÍ»ÝÖݵÄͬÐйýÀ´Ìý¿Î£¬ËùÒÔ˵ÅàѵµÄ¹æ¸ñ»¹ÊÇͦ¸ßµÄ¡£ÆäÖÐÓÐһλÑ¹Ù£¬Ìý˵»¹ÊǸ߼¶¾¯¹Ù£¬ËäȻ˾ ......