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Ϊ³¤¶È£¬ÒÔ
Ïà¹ØÎĵµ£º
ÊÕ²ØÓÚhttp://dev.yesky.com/296/8090796.shtml
OracleÊý¾Ý¿â
ÖйÜÀí±í¿Õ¼äºÍÊý¾ÝÎļþ
Êý¾Ý¿âµÄÈý´ó×é³É²¿·Ö:Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬RedoÈÕÖ¾¡£
±í¿Õ¼ä·ÖΪϵͳ±í¿Õ¼äºÍ·Çϵͳ±í¿Õ¼ä¡£
SYSTEM±í¿Õ¼äÊÇ×î»ù±¾µÄ£¬±ØÐëµÄ£¬Oracle½¨ÒéÄãΪÓû§Êý¾Ý£¬Óû§Ë÷Òý£¬UndoÊý¾Ý¶Î£¬ÁÙʱÊý¾Ý¶Î´´½¨µ¥¶ÀµÄ±í¿Õ¼ä ......
·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......
Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£>ÉèÖã>¿ØÖÆÃæ°å£>¹ÜÀí¹¤¾ß£>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£>³ÌÐò£>Oracle – OraDb10g_home1>Oracle Installation Products£> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal I ......