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

C#»·¾³ÏÂÍùoracleÖеÄblob×ֶβåÈëÎļþ

Ìí¼ÓÒýÓà           
using System.Data.OracleClient;
Ö÷ÒªÓõ½ÁËÁ½¸öÀà
System.Data.OracleClient.OracleConnection ±íʾһ¸öµ½Êý¾Ý¿âµÄÁ¬½Ó¡£´ËÀàÎÞ·¨¼Ì³Ð¡£
System.Data.OracleClient.OracleCommand   ±íʾÕë¶ÔÊý¾Ý¿âÖ´ÐÐµÄ SQL Óï¾ä»ò´æ´¢¹ý³Ì¡£´ËÀàÎÞ·¨¼Ì³Ð¡£
m_pathΪÒѾ­»ñÈ¡µÄÎļþÃû(full name)
±íFJ_SÖж¨ÒåÁËÈý¸ö×Ö¶ÎXM_ID(varchar(50)),XM_NAME(varchar(50),FJ_FILE(blob)
        private bool InputRecordToOracle(string sFilePath
        {
            if (m_Path == null)
            {
                return false;
            }
            //»ñµÃÎļþÁ÷
            System.IO.FileStream pFS = new System.IO.FileStream(m_Path, FileMode.Open, FileAccess.Read);
            Byte[] pBuffer = new Byte[pFS.Length];//°ÑÎļþת³ÉByteÐͶþ½øÖÆÁ÷
            pFS.Read(pBuffer, 0, pBuffer.Length);//°Ñ¶þ½øÖÆÁ÷¶ÁÈ뻺³åÇø
            pFS.Close();
            try
            {
                string sConnecStr = "Data Source=*;User ID=*;Password=*";
                OracleConnection pConn = new OracleConnection(sConnecStr);
          &n


Ïà¹ØÎĵµ£º

ÈçºÎÔÚORACLEÖе¼Èëµ¼³ödmpÎļþ£¿

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
DOSÖп ......

ÈçºÎ¼ÓËÙOracle´óÅúÁ¿Êý¾Ý´¦Àí

ÈçºÎ¼ÓËÙ
Oracle
´óÅúÁ¿Êý¾Ý´¦Àí
Ò»¡¢          
Ìá¸ß
DML
²Ù×÷µÄ°ì·¨£º
¼òµ¥ËµÀ´£º
£±¡¢ÔÝÍ£Ë÷Òý£¬¸üкó»Ö¸´.
±ÜÃâÔÚ¸üеĹý³ÌÖÐÉæ¼°µ½Ë÷ÒýµÄÖØ½¨.
£²¡¢ÅúÁ¿¸üУ¬Ã¿¸üÐÂһЩ¼Ç¼ºó¼°Ê±½øÐÐÌá½»¶¯×÷.
±ÜÃâ´óÁ¿Õ¼Óûعö¶ÎºÍ»òÁÙʱ±í¿Õ¼ä.
£³¡¢´´½¨Ò»ÁÙʱ ......

Oracle ±¸·Ý Óë »Ö¸´ ¸ÅÊö


ÍæOracleÒ²ÓÐ2ÄêµÄʱ¼äÁË£¬ ÁãÁãɢɢµÄÒ²ÕûÀíһЩ×ÊÁÏ¡£ ¶«Î÷Ò»¶àÁË£¬¾ÍÀí²»Çå³þ¡£ ËùÒÔ½áºÏÕÅÏþÃ÷µÄ¡¶´ó»°Oracle RAC¡·µÄһЩÄÚÈÝ£¬ºÍ×Ô¼ºÕûÀíµÄһЩ±Ê¼Ç£¬¶ÔOracle µÄ±¸·ÝºÍ»Ö¸´×öÁËÒ»¸öϵͳµÄÕûÀí¡£ Ò²ÊÇ×Ô¼º¶Ô֪ʶµÄÒ»¸ö¹®¹Ì°É¡£ 
Ò»£® ×¼±¸ÖªÊ¶
ÏÈÀ´¿´Ò»Ð©×¼±¸ÖªÊ¶£¬Á˽â ......

oracle dblink µÄÓ¦ÓÃ

oracle dblink µÄÓ¦ÓÃ
url:http://blog.chinaunix.net/u/19820/showart_334013.html
1¡¢ÓÃdblinkÁ´½Óoracle
£¨1£©ÓëÆ½Ì¨Î޹صÄд·¨£º
create public database
link cdt connect to apps
identified by apps using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.205.100)(PORT = 15 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ