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

Oracle 10.2.0.3 Patch°²×°

      Oracle 10.2.0.1µÄPatchµµÖð½¥ÐγÉÁ˼Ò×åÌåϵÁË,ÏÖÔÚÈôó¼ÒÀ´ÈÏʶһÏÂÕâ¸öÌåϵ°É!µ½Ä¿Ç°Ëù·¢²¼µÄÖ÷ÒªµÄPatchÓÐ10.2.0.2,10.2.0.3,10.2.0.4,10.2.0.4.1,10.2.0.4.2,10.2.0.4.3,10.2.0.5.
      ֮ǰÔÚ32λºÍ64λLinuxÏ°²×°Á˽ÏΪÎȶ¨µÄOracle 10G for Linux x86ºÍOracle 10G for Linux x86_64,ÓÉÓÚûÓÐÏÂÔØPatchµµ,ÈÃÎÒÒ»Ö±¶¼ÓÐÒ»ÖÖÏë·¨,Ò»¶¨ÒªÔÚ²âÊÔ»úÆ÷ÉÏ´òÉÏPatch.
      ×î½üÔÚѧϰRAC¼¼Êõ,ÔÚÐéÄâ»úÉÏ°²×°Oracle 10G for Linux x86 and Oracle 10G for Linux x84_64,Òò´ËPatchÐèÒª´òµ½10.2.0.3.Ôڴ˽«Ò»Ð©°²×°²½ÖèºÍÐĵÃÓë´ó¼Ò·ÖÏí:
      1).ÏÂÔØOracle 10.2.0.3µÄPatch
      2).½âѹ²¢·Åµ½/home/oracleĿ¼ÏÂ,ÒÔ±ã½øÐа²×°
      3).reboot Linux,È»ºóÒÔOracle User½øÈëϵͳ
      4).shutdown Databse,Stop all Oracle Service.
      5).Cool Backup Database
      6).Congratulation,You could run program of Patch
      ×¢Òâ:Èç¹ûûÓд´½¨Êý¾Ý¿â,Éý¼¶¾Í½áÊøÁË,Èç¹ûÉý¼¶ÒѾ­´´½¨Êý¾Ý¿â,ÐèÒªÖ´ÐÐÒ»ÏÂÒÔϵIJÙ×÷
      7).startup upgrade; lsnrctl start
        7.1).WindowsÏ°²×°ÐèÒªÐÞ¸Äjava_pool_size / large_pool_size=150M
        7.2).ͬʱÔËÐнű¾@rdbms/admin/catupgrd.sql
      8).shutdown immediate
      9).startup
      10).WindowsÏÂÐèÒªÔËÐнű¾@rdbms/admin/utlrp.sql
      11).--²ì¿´Êý¾Ý¿â°²×°µÄ×é¼þ\°æ±¾\״̬:
       col  com_name format a30
       col  version      format  a30
       col status         format  a10
      SELECT COMP_NAME,VERSION,STATUS from DBA_


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

Èý²½½ÌÄãÕÆÎÕOracleÍⲿ±í

Íâ±í(external table)¾ÍÏñÆÕͨµÄ±í¶ÔÏñÒ»Ñù£¬¿ÉÒÔselectµÈ£¬Ö»ÊÇËüÊÇÖ»¶ÁµÄ£¬Êý¾Ý¿âÖÐÖ»±£´æÁ˱í½á¹¹µÄÃèÊö£¬±íÊý¾ÝȴûÓдæ·ÅÔÚÊý¾Ý¿âÄÚ£¬¶øÊÇ´æ·ÅÔÚÁËÎļþϵͳÉÏ¡£µ±Óû§Ï뿶ûʹÓÃÊý¾Ý¿âÍâµÄ½á¹¹»¯Êý¾Ýʱ£¬ÓÃÆðÍâ±íÀ´¾Í·Ç³£·½±ã£¬ÉõÖÁ±Èsqlldr¶¼Òª·½±ãµÄ¶à¡£ÔÚÕâƪÎÄÕÂÀÎÒÃÇΪ´ó¼ÒÑÝʾÁË
¡¡¡¡Èý²½¾ÍÕÆÎÕoracleÍâ±í¹ý ......

ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ

Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracle ÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR Oracle ÀïÃæ×î´ó³¤¶ÈΪ 4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHAR Ç°Õß×î´ó³¤¶È2kb ......

Java»ñÈ¡Oracle´æ´¢¹ý³ÌÖÐÖ´Ðвéѯ·µ»ØµÄ½á¹û¼¯

ͨ¹ýJAVAµ÷ÓÃORACLEµÄ´æ´¢¹ý³Ì£¬ÔÚORACLEµÄ´æ´¢¹ý³ÌÄÚ²¿×öÁËÒ»¸ö²éѯÔÚJAVAÖлñÈ¡¸Ã²éѯ½á¹û£¬Õâ¸öºÍSYBASE¡¢SQLSERVERµÄ»ñÈ¡²»Ò»Ñù£¬µÈÎÒµÄÏÂһƪÎÄÕÂÎÒ»á½éÉÜÈçºÎ»ñÈ¡SYBASE¡¢SQLSERVERÔÚ´æ´¢¹ý³ÌÖÐÖ´ÐÐÁ˲éѯºóÈçºÎ»ñÈ¡Æä½á¹û¼°´æ´¢¹ý³ÌµÄ±àд¡£
ÔÚOracleÖÐÐèÒª·µ»Ø²éѯ½á¹û¼¯£¬±ØÐ뽫ÆäÒÔÓαêµÄÐÎʽ·µ»Ø£¬µ«ÓαêÓÖ²»ÊÇ ......

ORACLE NLS_LANG²ÎÊýÏê½â

NLS_LANG²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG= <Language>_ <Territory>. <Clients Characterset>
ÆäÖУº
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄÏ°¹ß
CHARACTERSET:
-¿ØÖÆ¿Í»§¶ËÓ¦ÓóÌÐòʹÓõÄ×Ö·û¼¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ