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

OracleϵÁУºLOB´ó¶ÔÏó´¦Àí

 OracleϵÁУºLOB´ó¶ÔÏó´¦Àí
 Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£
 Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
 
Ò»£¬OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
 1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
  ¢Ù×Ö·ûÀàÐÍ£º
   CLOB:´æ´¢´óÁ¿ µ¥×Ö½Ú ×Ö·ûÊý¾Ý¡£
   NLOB:´æ´¢¶¨¿í ¶à×Ö½Ú ×Ö·ûÊý¾Ý¡£
  ¢Ú¶þ½øÖÆÀàÐÍ£º
   BLOB:´æ´¢½Ï´óÎ޽ṹµÄ¶þ½øÖÆÊý¾Ý¡£
  ¢Û¶þ½øÖÆÎļþÀàÐÍ£º
   BFILE:½«¶þ½øÖÆÎļþ´æ´¢ÔÚÊý¾Ý¿âÍⲿµÄ²Ù×÷ϵͳÎļþÖС£´æ·ÅÎļþ·¾¶¡£
 
 2£¬°´´æ´¢·½Ê½·Ö£º
   ¢Ù´æ´¢ÔÚÄÚ²¿±í¿Õ¼ä£º
    CLOB£¬NLOBºÍBLOB
   ¢ÚÖ¸ÏòÍⲿ²Ù×÷ϵͳÎļþ£º
    BFILE
¶þ£¬´ó¶ÔÏóÊý¾ÝµÄ¼Èë
 1£¬ÉùÃ÷LOBÀàÐÍÁÐ
  /*
   conn scott/tiger;
   Create TableSpace ts5_21
      DataFile 'E:\Oracle\ts5_21.dbf'
   Size 5m;
  */
  Create Table tLob (
     no Number(4),
     name VarChar2(10),
     resume CLob,
     photo BLob,
     record BFile
    )
  Lob (resume,photo)Store As (
   Tablespace ts5_21  --Ö¸¶¨´æ´¢µÄ±í¿Õ¼ä
   Chunk 6k  --Ö¸¶¨Êý¾Ý¿é´óС
   Disable Storage In Row
  );
 2£¬²åÈë´ó¶ÔÏóÁÐ
  ¢ÙÏȲåÈëÆÕͨÁÐÊý¾Ý
 
  ¢ÚÓöµ½´ó¶ÔÏóÁÐʱ£¬²åÈë¿Õ°×¹¹Ô캯Êý¡£
   ×Ö·ûÐÍ£ºempty_clob()£¬empty_nclob()
   ¶þ½øÖÆÐÍ£ºempty_blob()
   ¶þ½øÖÆÎļþÀàÐÍ£ºBFileNameº¯ÊýÖ¸ÏòÍⲿÎļþ¡£
     BFileNameº¯Êý£º
      BFileName(‘Âß¼­Ä¿Â¼Ãû’£¬‘ÎļþÃû’);
      Âß¼­Ä¿Â¼ÃûÖ»ÄÜ´óд£¬ÒòΪÊý¾Ý´ÊµäÊÇÒÔ´óд·½Ê½´æ´¢¡£OracleÊÇÇø·Ö´óСдµÄ¡£
      ÔÚ´´½¨Ê±£¬ÎÞÐ轫BFileNameº¯ÊýÂß¼­Ä¿Â¼Ö¸ÏòÎïÀí·¾¶£¬Ê¹ÓÃʱ²Å×ö¼ì²é¶þÕßÊÇ·ñ¹ØÁª¡£
&nb


Ïà¹ØÎĵµ£º

oracleϵͳ±í²éѯ¡¾GBUnix¡¿

¡¾×ª¡¿http://www.gbunix.com/htmldata/2004_06/2/5/article_53_1.html
oracleϵͳ±í²éѯ¡¾GBUnix¡¿
 
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * fro ......

win7 °²×° oracle ¿Í»§¶Ë

µ±Ç°Èκΰ汾µÄORACLE¿Í»§¶ËÔÚÈκΰ汾µÄWINDOWS7É϶¼²»ÄÜÕý³£Íê³É°²×°¡£
    Ö÷ÒªÊÇÒòΪORACLE°²×°µÄÏȾöÌõ¼þÀï²Ù×÷ϵͳ°æ±¾²»·ûºÏ£¬µ«ÊÇÕâ¸öÒÉÎÊ¿ÉÒÔÐÞ¸Ärefhost.xml´¦Àí£¬ ¾ßÌåÊÇÔÚrefhost.xmlÖÐÌí¼Ó
  <!--Microsoft Windows 7-->
  <OPERATING_SYSTEM>
    & ......

Oracle °ó¶¨±äÁ¿


oracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×öÈí½âÎö.
Ò»¸öÓ²½âÎöÐèÒª¾­½âÎö,Öƶ¨Ö´Ðз¾¶,ÓÅ»¯·ÃÎʼƻ®µÈÐí¶àµÄ²½Öè.Ó²½âÊͲ»½ö½öºÄ·Ñ´óÁ¿µÄcpu£¬¸üÖØÒªµÄÊÇ»áÕ¼¾ÝÖØÒªµÄÃÇãÅ£¨latch£©×ÊÔ´£¬ÑÏÖصÄÓ°ÏìϵͳµÄ¹æÄ£µÄÀ©´ó£¨¼´ÏÞÖÆÁËϵͳµÄ²¢·¢ÐУ©£¬ ¶øÇÒÒýÆðµÄÎÊÌâ ......

½éÉÜORACLE DATA GUARD

¡¾IT168¼¼ÊõÎĵµ¡¿
     DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
    DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼­STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ