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
Ïà¹ØÎĵµ£º
¡¾×ª¡¿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 ......
µ±Ç°Èκΰ汾µÄORACLE¿Í»§¶ËÔÚÈκΰ汾µÄWINDOWS7É϶¼²»ÄÜÕý³£Íê³É°²×°¡£
Ö÷ÒªÊÇÒòΪORACLE°²×°µÄÏȾöÌõ¼þÀï²Ù×÷ϵͳ°æ±¾²»·ûºÏ£¬µ«ÊÇÕâ¸öÒÉÎÊ¿ÉÒÔÐÞ¸Ärefhost.xml´¦Àí£¬ ¾ßÌåÊÇÔÚrefhost.xmlÖÐÌí¼Ó
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
& ......
oracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×öÈí½âÎö.
Ò»¸öÓ²½âÎöÐèÒª¾½âÎö,Öƶ¨Ö´Ðз¾¶,ÓÅ»¯·ÃÎʼƻ®µÈÐí¶àµÄ²½Öè.Ó²½âÊͲ»½ö½öºÄ·Ñ´óÁ¿µÄcpu£¬¸üÖØÒªµÄÊÇ»áÕ¼¾ÝÖØÒªµÄÃÇãÅ£¨latch£©×ÊÔ´£¬ÑÏÖصÄÓ°ÏìϵͳµÄ¹æÄ£µÄÀ©´ó£¨¼´ÏÞÖÆÁËϵͳµÄ²¢·¢ÐУ©£¬ ¶øÇÒÒýÆðµÄÎÊÌâ ......
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......