ORACLE LOB ´ó¶ÔÏó´¦Àí
LOB´ó¶ÔÏó´¦Àí£º Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£ Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
Ò». OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
¢Ù×Ö·ûÀàÐÍ£º
CLOB:´æ´¢´óÁ¿ µ¥×Ö½Ú ×Ö·ûÊý¾Ý¡£
NLOB:´æ´¢¶¨¿í ¶à×Ö½Ú ×Ö·ûÊý¾Ý¡£
¢Ú¶þ½øÖÆÀàÐÍ£º
BLOB:´æ´¢½Ï´óÎ޽ṹµÄ¶þ½øÖÆÊý¾Ý¡£
¢Û¶þ½øÖÆÎļþÀàÐÍ£º
BFILE:½«¶þ½øÖÆÎļþ´æ´¢ÔÚÊý¾Ý¿âÍⲿµÄ²Ù×÷ϵͳÎļþÖС£´æ·ÅÎļþ·¾¶¡£
2£¬°´´æ´¢·½Ê½·Ö£º
¢Ù´æ´¢ÔÚÄÚ²¿±í¿Õ¼ä£º
CLOB£¬NLOBºÍBLOB
¢ÚÖ¸ÏòÍⲿ²Ù×÷ϵͳÎļþ£º
BFILE
¶þ£¬´ó¶ÔÏóÊý¾ÝµÄ¼Èë
2.1£¬ÉùÃ÷LOBÀàÐÍÁÐ
Create TableSpace Dave DataFile 'D:\Dave\dave.dbf' Size 20m;
Create Table tLob (
no Number(4),
name VarChar2(10),
resume CLob,
photo BLob,
record BFile
)
Lob (resume,photo)Store As (
Tablespace dave --Ö¸¶¨´æ´¢µÄ±í¿Õ¼ä
Chunk 6k --Ö¸¶¨Êý¾Ý¿é´óС
Disable Storage In Row
);
2£¬²åÈë´ó¶ÔÏóÁÐ
¢ÙÏȲåÈëÆÕͨÁÐÊý¾Ý
¢ÚÓöµ½´ó¶ÔÏóÁÐʱ£¬²åÈë¿Õ°×¹¹Ô캯Êý¡£
×Ö·ûÐÍ£ºempty_clob()£¬empty_nclob()
¶þ½øÖÆÐÍ£ºempty_blob()
¶þ½øÖÆÎļþÀàÐÍ£ºBFileNameº¯ÊýÖ¸ÏòÍⲿÎļþ¡£
BFileNameº¯Êý£º
BFileName(‘Â߼Ŀ¼Ãû’£¬‘ÎļþÃû’);
Â߼Ŀ¼ÃûÖ»ÄÜ´óд£¬ÒòΪÊý¾Ý´ÊµäÊÇÒÔ´óд·½Ê½´æ´¢¡£OracleÊÇÇø·Ö´óСдµÄ¡£
ÔÚ´´½¨Ê±£¬ÎÞÐ轫BFileNameº
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆΪsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È»ºóÔÙ´ ......
Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORD ......
ÔÚµ¼ÍêÊý¾ÝÖ®ºó·¢ÏÖ oracleµÄ°²×°ÅÌÖ»Óм¸MµÄ¿Õ¼äÁË¡£
ÏÖÔÚÓÐÁ½¸ö·½°¸¿ÉÒÔÑ¡Ôñ
1.°ÑÊý¾ÝÎļþתÒƵ½ÁíÍâÒ»¸öÅÌÈ¥¡£
ÎÒµ¼Êý¾ÝµÄʱºòÊÇÕâÑù×öµÄ 1.н¨Ò»¸ö±í¿Õ¼ä£¬Îª±í¿Õ¼äÌí¼ÓÒ»¸öÊý¾ÝÎļþ£¨assure_dt£©¡£2.н¨Óû§£¬±í¿Õ¼äÖ¸Ïò²½Öè1н¨µÄ±í¿Õ¼ä¡£
È»ºóµ¼Èë¡£ÎÒÓõÄÊÇoracle 10g
ÎÊÌâ1.ΪʲôÎÒÌí¼ÓµÄÊý¾ÝÎļþas ......