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

oracleµÄÊý¾ÝÀàÐÍ

ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
    ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£
    ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
¢ÙÊý×Ö
¡¡
    ÓÐÈýÖÖ»ù±¾ÀàÐÍ:NUMBER¡¢PLS_INTEGERºÍBINARY_INTENER¡£
NUMBER
    ¿ÉÒÔÃèÊöÕûÊý»òʵÊý£¬¶øPLS_INTEGERºÍBINARY_INTENERÖ»ÄÜÃèÊöÕûÊý¡£ NUMBER£¬ÊÇÒÔÊ®½øÖƸñʽ½øÐд洢µÄ£¬Ëü±ãÓÚ´æ´¢£¬µ«ÊÇÔÚ¼ÆËãÉÏ£¬ÏµÍ³»á×Ô¶¯µÄ½«Ëüת»»³ÉΪ¶þ½øÖƽøÐÐÔËËãµÄ¡£ËüµÄ¶¨Ò巽ʽÊÇNUMBER(P£¬S)£¬PÊǾ«¶È£¬×î´ó38룬SÊǿ̶ȷ¶Î§£¬¿ÉÔÚ-84...127¼äȡֵ¡£ÀýÈ磺NUMBER(5£¬2)¿ÉÒÔÓÃÀ´´æ´¢±íʾ-999.99...999.99 ¼äµÄÊýÖµ¡£
P¡¢S¿ÉÒÔÔÚ¶¨ÒåÊÇÊ¡ÂÔ£¬ÀýÈ磺NUMBER(5)¡¢NUMBERµÈ£»
BINARY_INTENER
      ÓÃÀ´ÃèÊö²»´æ´¢ÔÚÊý¾Ý¿âÖУ¬µ«ÊÇÐèÒªÓÃÀ´¼ÆËãµÄ´ø·ûºÅµÄÕûÊýÖµ¡£ËüÒÔ2µÄ²¹Âë¶þ½øÖÆÐÎʽ±íÊö¡£Ñ­»·¼ÆÊýÆ÷¾­³£Ê¹ÓÃÕâÖÖÀàÐÍ¡£
PLS_INTEGER
      ºÍBINARY_INTENERÎ¨Ò»Çø±ðÊÇÔÚ¼ÆËãµ±Öз¢ÉúÒç³öʱ£¬BINARY_INTENERÐ͵ıäÁ¿»á±»×Ô¶¯Ö¸ÅɸøÒ»¸öNUMBERÐͶø²»»á³ö´í£¬PLS_INTEGERÐ͵ıäÁ¿½«»á·¢Éú´íÎó¡£
¢Ú×Ö·û¡¡°üÀ¨CHAR¡¢VARCHAR2(VARCHAR)¡¢LONG¡¢NCHARºÍNVARCHAR2¼¸ÖÖÀàÐÍ¡£
CHAR¡¡
ÃèÊö¶¨³¤µÄ×Ö·û´®£¬Èç¹ûʵ¼ÊÖµ²»¹»¶¨ÒåµÄ³¤¶È£¬ÏµÍ³½«ÒÔ¿Õ¸ñÌî³ä¡£ËüµÄÉùÃ÷·½Ê½ÈçÏÂ
CHAR(L)¡¡
LΪ×Ö·û´®³¤¶È£¬È±Ê¡Îª1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£
VARCHAR2(VARCHAR)
¡¡ÃèÊö±ä³¤×Ö·û´®¡£ËüµÄÉùÃ÷·½Ê½ÈçÏ VARCHAR2(L)£¬LΪ×Ö·û´®³¤¶È£¬Ã»ÓÐȱʡֵ£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö½Ú£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ4000¡£ÔÚ¶à×Ö½ÚÓïÑÔ»·¾³ÖУ¬Êµ¼Ê´æ´¢µÄ×Ö·û¸öÊý¿ÉÄÜСÓÚLÖµ£¬ÀýÈ磺µ±ÓïÑÔ»·¾³ÎªÖÐÎÄ(SIMPLIFIED CHINESE_CHINA.ZHS16GBK)ʱ£¬Ò»¸öVARCHAR2(200)µÄÊý¾ÝÁпÉÒÔ±£´æ200¸öÓ¢ÎÄ×Ö·û»òÕß100¸öºº×Ö×Ö·û¡£
LONG
¡¡ÔÚÊý¾Ý¿â´æ´¢ÖпÉÒÔÓÃÀ´±£´æ¸ß´ï2GµÄÊý¾Ý£¬×÷Ϊ±äÁ¿£¬¿ÉÒÔ±íʾһ¸ö×î´ó³¤¶ÈΪ32760×ֽڵĿɱä×Ö·û´®¡£
NCHAR¡¢NVARCHAR2
¡¡¹ú¼Ò×Ö·û¼¯£¬Óë»·¾³±äÁ¿NLSÖ¸¶¨µÄÓïÑÔ¼¯ÃÜÇÐÏà¹Ø£¬Ê¹Ó÷½·¨ºÍCHAR¡¢VARCHAR2Ïàͬ¡£
¢ÛÐÐ
°üÀ¨RAWºÍLONG RAWÁ½ÖÖÀàÐÍ¡£ÓÃÀ´´æ´¢¶þ½øÖÆÊý¾Ý£¬²»»áÔÚ×Ö·û¼¯¼äת»»¡£
RAW
ÀàËÆÓÚCHAR£¬ÉùÃ÷·½Ê½RAW(L)£¬LΪ³¤¶È£¬ÒÔ


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

²Ù×÷oracleÖеÄÊý¾ÝÎļþ

ÊÕ²ØÓÚhttp://dev.yesky.com/296/8090796.shtml
OracleÊý¾Ý¿â
ÖйÜÀí±í¿Õ¼äºÍÊý¾ÝÎļþ

 
Êý¾Ý¿âµÄÈý´ó×é³É²¿·Ö:Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬RedoÈÕÖ¾¡£
±í¿Õ¼ä·ÖΪϵͳ±í¿Õ¼äºÍ·Çϵͳ±í¿Õ¼ä¡£
 
SYSTEM±í¿Õ¼äÊÇ×î»ù±¾µÄ£¬±ØÐëµÄ£¬Oracle½¨ÒéÄãΪÓû§Êý¾Ý£¬Óû§Ë÷Òý£¬UndoÊý¾Ý¶Î£¬ÁÙʱÊý¾Ý¶Î´´½¨µ¥¶ÀµÄ±í¿Õ¼ä ......

ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿


ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿ 
 
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨Ô­ÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2  Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......

ORACLEÊý¾Ý¿âÄÚ´æ²ÎÊýÉè´óÓÚ8GµÄÄÚ´æÆô¶¯³ö´íÎÊÌâ½â¾ö


ORACLEÊý¾Ý¿âÄÚ´æ²ÎÊýÉè´óÓÚ8GµÄÄÚ´æÆô¶¯³ö´íÎÊÌâ½â¾ö 
 
4¸öINTEL 1.6g 4ºËCPU£¬16G Äڴ棬°²×°ÍêORACLE 10G FOR RED HAT LINUX£­64UPDATA4X86-64  ×¼±¸µ¼Êý¾Ý½øÈ¥£¬Ë³ÊÖÐÞ¸ÄÁ˼¸¸ö²ÎÊý¡£
alter system set sga_max_size=11g scope=spfile;
alter system  set sga_target=11g scope=spfile ......

Íêȫɾ³ýOracle 10g

Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£­>ÉèÖã­>¿ØÖÆÃæ°å£­>¹ÜÀí¹¤¾ß£­>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£­>³ÌÐò£­>Oracle – OraDb10g_home1>Oracle Installation Products£­> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal I ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ