¡¾×ª¡¿ORACLE BLOB BFILE ÎļþµÄ¼Èë¼°¶ÁÈ¡
Èç¹ûÄã½Ó´¥¹ýmysqlµÄ»°Ò»¶¨¶ÔmysqlµÄtextºÍblob²»»áÄ°Éú£¬ÔÚmysqlÖÐÊÇÖ±½Ó²Ù×÷textºÍblobµÄ¡£µ«ÊÇÔÚoracleÖУ¬Ëü°Ñlob×öΪһÖÖÌØÊâµÄ×ֶΣ¬²»ÄÜÖ±½Ó½øÐвÙ×÷--±ÈÈç²»ÄÜÖ±½Ó²åÈëµ½lob×Ö¶ÎÖУ¬Ò²²»ÄÜÓÃlike²éѯµÈµÈ¡£
ÕâÀïÊÇÎÒ±£´æµÄһƪÕâ·½ÃæµÄÎÄÕ£¬ÔÎÄ°á¹ýÀ´£¬ÓÉÓÚ±£´æµÄʱºòÖ»ÊÇÈ¡ÁËÒ»²¿·Ö£¬Ã»Í·Ã»Î²µÄ£¬ËùÒÔû·¨ÕÒµ½ÔÀ´µÄ³ö´¦¡£
²»ÄÜÖ±½ÓÓÃINSERTÓï¾äÏòLOB×Ö¶ÎÖвåÈëÖµ¡£Ò»°ãÇé¿öÏ£¬ÓÐÈçϵļ¸²½£º
1 ÏÈ·ÖÎöÒ»¸öINSERTÓï¾ä£¬·µ»ØÒ»¸öLOBµÄÃèÊö·û
2 ÓÃOCIº¯ÊýÉú³ÉÒ»¸ö±¾µØµÄLOB¶ÔÏó
3 ½«LOB¶ÔÏó°ó¶¨µ½LOBÃèÊö·ûÉÏ
4 Ö´ÐÐINSERTÓï¾ä
5 ¸øLOB¶ÔÏó¸³Öµ
6 ÊÍ·ÅLOB¶ÔÏóºÍSQLÓï¾ä¾ä±ú
ÏÂÃæµÄÕâ¸öÀý×ÓÊÇ°ÑÓû§ÉÏ´«µÄͼƬÎļþ´æ·Åµ½BLOB£¨»òBFILEÖУ¬²Ù×÷ÉÔÓв»Í¬£©ÖС£
Ê×ÏÈÒª½¨Ò»¸ö±í£¬½á¹¹ÈçÏ£º
CREATE TABLE PICTURES (
ID NUMBER,
DESCRIPTION VARCHAR2(100),
MIME VARCHAR2(128),
PICTURE BLOB
);
Èç¹ûҪʵÏÖIDµÄ×Ô¶¯Ôö¼Ó£¬ÔÙ½¨Ò»¸öSEQUENCE:
CREATE SEQUENCE PIC_SEQ;
È»ºóÊÇÓÃÀ´´¦ÀíÊý¾ÝµÄPHP³ÌÐò´úÂë¡£
<?php
//½¨Á¢OracleÊý¾Ý¿âÁ¬½Ó
$conn = OCILogon($user, $password, $SID);
//Ìá½»SQLÓï¾ä¸øOracle
//ÔÚÕâÀïҪעÒâµÄÁ½µã£ºÒ»ÊÇÓÃEMPTY_BLOB()º¯Êý¡£ÕâÊÇOracleµÄÄÚ²¿º¯Êý£¬·µ»ØÒ»¸öLOBµÄ¶¨Î»·û¡£ÔÚ²åÈëLOBʱ£¬Ö»ÄÜÓÃÕâ¸ö°ì·¨ÏÈÉú³ÉÒ»¸ö¿ÕµÄLOB¶¨Î»·û£¬È»ºó¶ÔÕâ¸ö¶¨Î»·û½øÐвÙ×÷¡£EMPTY_BLOB()º¯ÊýÊÇÕë¶ÔBLO
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Óï·¨£º
select *
from ±íÃû
where Ìõ¼þ1
start with Ìõ¼þ2
connect by prior µ±Ç°±í×Ö¶Î=¼¶Áª±í×Ö¶Î
start withÓëconnect by priorÓï¾äÍê³ÉµÝ¹é¼Ç¼£¬ÐγÉÒ»¿ÃÊ÷Ðνṹ£¬Í¨³£¿ÉÒÔÔÚ¾ßÓвã´Î½á¹¹µÄ±íÖÐʹÓá£
start with±íʾ¿ªÊ¼µÄ¼Ç¼
connect by prior Ö¸¶¨Ó뵱ǰ¼Ç¼¹ØÁªÊ±µÄ×ֶιØϵ
´úÂ룺
--´´½¨²¿Ãű ......
Oracle±í¿Õ¼äµÄ¹ÜÀí
1.´´½¨±í¿Õ¼ä
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
&nbs ......
µÇ½ORACLEʱ³öÏÖ£ºORA-12637 °ü½ÓÊÜʧ°Ü ´íÎó
½â¾ö·½·¨£ºÔÚ\oracle\product\10.2.0\client_1\NETWORK\ADMIN ÖÐÕÒµ½sqlnet.oraÎļþ£¬
°ÑÐÞ¸Ä SQLNET.AUTHENTICATION_SERVICES= (NONE)¾Í¿ÉÒÔÁË¡£ ......
×î½ü¹«Ë¾´òËãÔÚÏÂÒ»´ú¼Æ·ÑϵͳÀïÃæʹÓÃÄÚ´æÊý¾Ý¿âµÄ¼¼Êõ£¬ËùÒÔ×÷Ϊ¹«Ë¾µÄÉè¼ÆÈËÔ±Ö®Ò»µÄÎÒ£¬ÔÚoracleÍøÉÏÏÂÁ˸öTimesTen£¬°²×°ÔÚÎÒÃǵIJâÊÔ·þÎñÆ÷ÉÏÃæaix5£¬Õâƪ¶ÌÎÄÖ÷ÒªÊÇÎÒ²Ù×÷Êý¾Ý¿âµÄÒ»¸ö±Ê¼Ç£¬ÏÂһƪ´òËã·¢Ò»¸öc³ÌÐòµÄÀý×ÓºÍÎÒ²âÊԵĽá¹û£¬ºóÐø¿ÉÄÜ»¹»áʹÓÃTimesTen cache of oracleÕâ¸ö²úÆ·£¬Â½ÐøÒ²»á·¢Ò»ÏÂÕâ· ......