Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ɨä ORACLE RACµÄ°Ù¿Æ½éÉÜ

Oracle RAC
¡¡¡¡RAC£¬È«³Æreal application clusters£¬ÒëΪ“ÕæÕýÓ¦Óü¯Èº”£¬ ÊÇOracleаæÊý¾Ý¿âÖвÉÓõÄÒ»Ïîм¼Êõ£¬Ò²ÊÇOracleÊý¾Ý¿âÖ§³ÖÍø¸ñ¼ÆËã»·¾³µÄºËÐļ¼Êõ¡£
¡¡¡¡Oracle RACÖ÷ÒªÖ§³ÖOracle9i¡¢10g¡¢11g°æ±¾£¬¿ÉÒÔ¿ÉÒÔÖ§³Ö24 x 7 ÓÐЧµÄÊý¾Ý¿âÓ¦Óà ϵͳ£¬Ôڵͳɱ¾·þÎñÆ÷ÉϹ¹½¨¸ß¿ÉÓÃÐÔÊý¾Ý¿âϵͳ£¬²¢ÇÒ×ÔÓɲ¿ÊðÓ¦Óã¬ÎÞÐèÐ޸ĴúÂë¡£
¡¡¡¡ÔÚOracle RAC»·¾³Ï£¬Oracle¼¯³ÉÌṩÁ˼¯ÈºÈí¼þºÍ´æ´¢¹ÜÀíÈí¼þ£¬ÎªÓû§½µµÍÁËÓ¦Óóɱ¾¡£µ±Ó¦ÓùæÄ£ÐèÒªÀ©³äʱ£¬Óû§¿ÉÒÔ°´ÐèÀ©Õ¹ÏµÍ³£¬ÒÔ±£Ö¤ÏµÍ³µÄÐÔÄÜ¡£
¡¡¡¡Oracle RACÒ»°ãÒ²¿É¹¹½¨ÓÚ´óÐÍSMPÖ÷»ú£¬IBMµÄAIXϵÁзþÎñÆ÷ÍùÍùÊÇÆäÖи߶Ëƽ̨£¬Intel LinuxÍùÍù×÷ΪÆäµÍ¶Ëƽ̨¡£µ±AIX UNIXÓÃÀ´ÔËÐÐOracle RAC×÷Ϊ´óÐÍÊý¾Ý¿âϵͳƽ̨ʱ£¬Æ伯Ⱥϵͳ¹¹½¨¡¢ÊµÊ©¡¢ÔËά¡¢¸ß¿ÉÓÃÉèÖã¬ÓÐÆäƽ̨Ìص㡣¿ÉÒÔ²ÎÕÕ¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/UNIXÉϵÄʵսÏê½â¡·£¬¸ÃÊéÒÔAIX UNIXƽ̨ΪÖ÷Ïߣ¬ÒÔÆäËûUNIXϵͳΪ²ÎÕÕ£¬ÃèÊöÁËÊý¾Ý¿âϵͳOracle 10g¡¢Oracle 11gµÄRACµÄ¹¹¼Ü·½·¨ºÍ¹ý³Ì¡£ÔÚLinuxƽ̨£¬Ôò¡¶´ó»°OracleRAC¼¯Èº¡¢¸ß¿ÉÓÃÐÔ¡¢±¸·ÝÓë»Ö¸´¡·ÓÐןܺõÄÂÛÊö¡£
      PowerBuilder 11ÒÔºóµÄ°æ±¾,ÔÚÔ­Óлù´¡ÉÏÔö¼ÓÁ˶Ôoracle racµÄÖ§³Ö.ÁíÍ⻹Ôö¼ÓÁ˶Ômobilink(Ó¦¸ÃÊÇSQL anywhereµÄͬ²½¼¼Êõ°É?)µÄÖ§³Ö.


Ïà¹ØÎĵµ£º

oracle ±í½á¹¹µÄÐÞ¸Ä

oracle ±í½á¹¹µÄÐÞ¸Ä
½ñÌì×ܽáϹØÓÚ±íµÄÐÞ¸Ä,·ÀÖ¹ÒÔºóÍü¼Ç,ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·Âð!!!
¸ü¸Ä±íµÄ½á¹¹
1.±à¼­±íµÄ×Ö¶Î
  ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
  Óï·¨:
    ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
 eg1:
   alter table ......

ORACLE ¶ÔÏóµÄʹÓÃ

--´´½¨¶ÔÏóÀàÐÍ
create or replace type emp_typ as object (
id number,
name varchar2(30),
sal number,
comm number,
member procedure change_comm(new_comm number),
member function get_info return  varchar2
) ;
--´´½¨¶ÔÏóÀàÐ͹¹Ô캯Êý¶¨Òå
create or replace type body emp_typ is
member proce ......

¡¾×ª¡¿ ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ

ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍƳöÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ ......

ÔÚOracleÖÐÉèÖÃ×Ô¶¯Ôö³¤ÁÐ


¡¾ÊµÏÖ²½Öè¡¿
 1. ´´½¨±íblog_info, ¾ßÓÐIDºÍtitleÁ½¸ö×Ö¶Î, ÆäÖÐID½«ÉèÖÃΪ×Ô¶¯Ôö³¤ÁÐ;
 2. ´´½¨ÐòÁÐ:
    create sequence sq_blog_info
    start with 1
    increment by 1
    nomaxvalue
    nocycle
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ