Oracle 11g R2ÐÂÌØÐÔ¸ÅÊö£¨×ª£©
µ¼¶Á£º
¡¡¡¡2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ¶àôºÃ£¬ÎÒÏàÐÅOracle¹«Ë¾Ñ¡ÔñÕâ¸öʱºò·¢²¼Ê±ÎªÁ˴̼¤²Î¼ÓOracle OpenWorld 2009´ó»áµÄÈËÐ˷ܺÍÆÚ´ý¡£
¡¡¡¡¾¹ýËÄ´¦ËÑË÷Oracle 11g R2ÐÂÌØÐÔÎĵµ£¬²¢ÌåÑéÁËеÄOUI(OracleͨÓð²×°³ÌÐò)£¬´´½¨ÁËÎҵĵÚÒ»¸öµ¥ÊµÀýRACºó£¬ÎÒ×ܽáÒ»ÏÂOracle 11g R2ÖÐÎÒ×îϲ»¶µÄÎå´óÐÂÌØÐÔ¡£ÔÚºóÃæµÄÎÄÕÂÖÐÎÒ½«Â½Ðø½éÉÜÆäËüÐÂÌØÐÔ£¬ÇëËø¶¨±¾ÏµÁÐÎÄÕ¡£
¡¡¡¡NO.1 Ëæ´¦¿É¼ûµÄ¼¯Èº
¡¡¡¡ÔÚÒÔÇ°µÄ°æ±¾ÖУ¬Oracle Clusterware±ØÐëÒª¶ÀÁ¢µØ°²×°ÔÚËü×Ô¼ºµÄORACLE HOMEÖУ¬²¢ÇÒÒ²Ö»ÄÜÔÚRAC»·¾³ÏÂʹÓã¬ÕâÒ»ÇÐÔÚOracle 11g R2µÃµ½³¹µ×µß¸²£¬ÒòΪÔÚÕâ¸ö°æ±¾ÖÐÖ§³Ö°²×°OracleÍø¸ñ»ù´¡¼Ü¹¹£¬¶øÇÒÖ»ÐèÒªÒ»¸ö¶ÀÁ¢µÄORACLE HOME£¬Ëü°üÀ¨ÁËOracle ClusterwareºÍOracle×Ô¶¯´æ´¢¹ÜÀí(ASM)¡£Í¨¹ýÉý¼¶ºóµÄOracleͨÓð²×°³ÌÐò°²×°ÁËÍø¸ñ»ù´¡¼Ü¹¹ºó£¬Ä㽫»á¿´µ½Ò»¸öÈ«ÐµĹ¦ÄܺͷþÎñ¾ØÕó£¬ÎÒ¼òµ¥µØÁоټ¸¸ö°É£º
¡¡¡¡µ¥ÊµÀýRAC(OracleÖØÆô)£ºÌýÆðÀ´Ëƺõ×ÔÏàì¶Ü£¬µ«Oracle 11g R2À©Õ¹ÁËOracle ClusterwareµÄ¹¦ÄÜ£¬ÎªÈκε¥ÊµÀýÌṩÁ˸߿ÉÓÃÌØÐÔ£¬±¾ÖÊÉÏÊǽ«Êý¾Ý¿â±ä³ÉÁ˵¥ÊµÀýRACÊý¾Ý¿â¡£Oracle 11g R2ÖеÄOracleÖØÆôÌØÐÔ°ïÖúOracleÍø¸ñ»ù´¡¼Ü¹¹µÄ¸ß¿ÉÓ÷þÎñ¿ØÖÆ·þÎñÆ÷ÖØÆôʱÄÄÒ»¸ö¼àÌýÆ÷£¬ASMʵÀýºÍÊý¾Ý¿âÓ¦¸ÃÆô¶¯£¬ËüÍêÈ«È¡´úÁ˹ýÈ¥DBAÃǾ³£Óõ½µÄDBSTART½Å±¾¡£Í¬Ñù£¬µ±µ¥¸öÊý¾Ý¿âʵÀý±ÀÀ£»òÆäËüÒì³£ÖÕֹʱ£¬OracleÖØÆô¹¦ÄÜ»á×Ô¶¯¼à²âʧЧµÄʵÀý£¬²¢×Ô¶¯ÖØÆôËü£¬¾ÍºÃÏñÊÇÔÚÒ»¸öÕæʵµÄRAC»·¾³ÖÐÒ»Ñù¡£
¡¡¡¡SRVCTLÉý¼¶£ºÈç¹ûÄã¹ÜÀí¹ý¾É°æ±¾µÄRAC»·¾³£¬Äã¿ÉÄÜÒѾÊìϤÁËRAC»·¾³ÖеÄά»¤¹¤¾ßSRVCTL£¬ÔÚ11g R2ÖУ¬¸Ã¹¤¾ß±»À©Õ¹ÁË£¬ÏÖÔÚ¿ÉÒÔ¹ÜÀíµ¥ÊµÀýRAC£¬ÒÔ¼°¼àÌýÆ÷ºÍASMʵÀý¡£
¡¡¡¡¼¯ÈºÊ±¼äͬ²½·þÎñ£ºOracle 11g R2ÏÖÔÚÐèÒªÔÚËùÓÐRAC½ÚµãÉÏÅäÖÃʱ¼äͬ²½£¬Èç¹ûÄãÔø¾¾Àú¹ýij¸ö½Úµã±»ÇýÖð³öRAC¼¯ÈºÅäÖã¬ÄãÒ»¶¨ÖªµÀÆäÄѶÈÓжà´ó£¬ÌرðÊÇÁ½¸ö·þÎñÆ÷µÄʱ¼ä²»Í¬²½ºÍÈÕÖ¾ÎļþµÄʱ¼ä´Á²»Í¬²½Ê±£¬Oracle֮ǰµÄ°æ±¾½èÖúϵͳÌṩµÄÍøÂçʱ¼äÐÒé(NTP)ͬ²½ËùÓнڵãʱ¼ä£¬µ«ÕâÐèÒªÁ¬½Óµ½»¥ÁªÍøÉϵıê׼ʱ¼ä·þÎñÆ÷£¬×÷ΪNTPµÄÌæ´úÕߣ¬Oracle 11g R2ÌṩÁËÒ»¸öеļ¯ÈºÊ±¼äͬ²½·þÎñ£¬È
Ïà¹ØÎĵµ£º
ĬÈϵÄÇé¿öÏ£¬Èç¹ûûÓÐÅäÖÃѹËõ±¸·Ý£¬»òÕß±¸·ÝµÄʱºòûÓз¢³öcompressed ÃüÁÄÇôORACLE»á²ÉÓÃNULLÊý¾Ý¿éµÄѹËõ·½·¨À´±¸·ÝÊý¾Ý¿â£¬²ÉÓÃÕâÖÖ·½·¨±¸·Ý£¬ORACLE¾Í²»»á±¸·Ý´ÓδʹÓùýµÄÊý¾Ý¿é¡£ÁíÍâÒ»ÖÖ±¸·Ý¾ÍÊDzÉÓÃcompressedÃüÁîѹËõ±¸·Ý£¬²ÉÓÃÕâÖÖ·½·¨£¬ORACLE»áʹÓÃѹËõËã·¨À´±¸·ÝÊý¾Ý£¬Í¨³£»á ......
select decode('X','Q','±äÁ¿1','±äÁ¿2') from dual
¡¡select sysdate,to_char(sysdate,’yyyy-mm-dd hh24:mi:ss’) from dual
¡¡
¡¡select to_date(’2003-10-17 21:15:37’,’yyyy-mm-dd hh24:mi:ss’) from dual
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû ......
oracle Âß¼±¸·ÝÃüÁîEXP/IMP²ÎÊý²Î¿¼ÊÖ²á
°ïÖúÃüÁexp help=y
Export: Release 10.2.0.1.0 - Production on Thu Jul 20 10:39:50 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed b ......
½¨±í
create table users(
id number(4) primary key,
username varchar2(10),
password varchar2(10)
)
²éѯ±í²¢½âËø±í(¼´¿ÉÒÔµã»÷ÊäÈë¿òÏÂÃæµÄ"Ëø"ͼ±ê¹¤¾ß, ¼´"Edit data")
select * from users for update
ɾ³ý±íÖжàÓàµÄÁÐ
alter table mobilephone drop column mobiletype
תÔØ
------------------- ......