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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇ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Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨ÔÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2 Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......
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 ......
Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£>ÉèÖã>¿ØÖÆÃæ°å£>¹ÜÀí¹¤¾ß£>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£>³ÌÐò£>Oracle – OraDb10g_home1>Oracle Installation Products£> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal I ......