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

¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷


import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55:06)
 * @author£ºzhubin
 */
public class BLOBUtil {
/**
 * ¹¦ÄÜ˵Ã÷£º±àÂ뷽ʽ
 * ȡֵ·¶Î§£º
 * ÒÀÀµÊôÐÔ£º
 * ×îºóÐÞ¸Äʱ¼ä£º(2002-2-27 15:30:40)
 */
private static String codeSet;
/**
 * ´Ë´¦²åÈë·½·¨ËµÃ÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:58:15)
 * @return java.lang.String
 * @param result java.sql.ResultSet
 * @param index int
 */
public static String readBLOB(ResultSet result, int index) throws IOException,
 SQLException
{
String strValue = null;
// ¶ÔÓÚSQL NULL£¬·½·¨getBinaryStream½«·µ»Ønull
InputStream in = result.getBinaryStream(index);
if (in == null) {
return "";
}
byte[] ba = new byte[8192];
ByteArrayOutputStream b = new ByteArrayOutputStream();
int i;
while((i = in.read(ba)) != -1){
b.write(ba, 0, i);
}
try{
strValue = b.toString(codeSet);
}catch(Exception e){
strValue = b.toString();
}
return strValue;
}
/**
 * ´Ë´¦²åÈë·½·¨ËµÃ÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:59:52)
 * @return java.lang.String
 * @param result java.sql.ResultSet
 * @param name java.lang.String
 */
public static String readBLOB(ResultSet result, String name) throws IOException,
SQLException
{
String strValue;
// ¶ÔÓÚSQL NULL£¬·½·¨getBinaryStream½«·µ»Ønull
InputStream in = result.getBinaryStream(name);
if (in == null) {
return "";
}
byte[] ba = new byte[8192];
ByteArrayOutputStream b = new ByteArrayOutputStream();
int i;
while((i = in.read(ba)) != -1){
b.write(ba, 0, i);
}
try{
strValue = b.toString(codeSet);
}catch(Exception e){
strValue = b.t


Ïà¹ØÎĵµ£º

ʹÓÃOracleÍⲿ±íµÄÎå¸öÏÞÖÆ

Íⲿ±íÊÇÖ¸²»ÔÚÊý¾Ý¿âÖÐµÄ±í£¬Èç²Ù×÷ϵͳÉϵÄÒ»¸ö°´Ò»¶¨¸ñʽ·Ö¸îµÄÎı¾Îļþ»òÕ߯äËûÀàÐÍµÄ±í¡£Õâ¸öÍⲿ±í¶ÔÓÚOracleÊý¾Ý¿âÀ´Ëµ£¬¾ÍºÃÏñÊÇÒ»ÕÅÊÓͼ£¬ÔÚÊý¾Ý¿âÖпÉÒÔÏñÊÔͼһÑù½øÐвéѯµÈ²Ù×÷¡£Õâ¸öÊÔͼÔÊÐíÓû§ÔÚÍⲿÊý¾ÝÉÏÔËÐÐÈκεÄSQLÓï¾ä£¬¶ø²»ÐèÒªÏȽ«Íⲿ±íÖеÄÊý¾Ý×°ÔØ½øÊý¾Ý¿âÖС£²»¹ýÐèҪעÒâÊÇ£¬ÍⲿÊý¾Ý±í¶¼ÊÇÖ»¶ ......

ÀûÓÃoracle¿ìÕÕdblink½â¾öÊý¾Ý¿â±íͬ²½ÎÊÌâ

±¾ÊµÀýÒÑÍêȫͨ¹ý²âÊÔ,µ¥Ïò,ÓÖÏòͬ²½¶¼¿ÉʹÓÃ.
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
            Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
ǰ6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink_orc9 ......

Ò»´ÎÏÖ³¡oracle 9i ÐÔÄܵ÷ÓÅ

µÚÒ»²½
   ¶ÔÊý¾Ý¿âÕûÌå×öÁËÒ»¸öÁ˽â
$ORACLE_HOME/bin/sqlplus "sys/sys061201 as sysdba" << EOF
spool peiyz_healthcheck_info.txt
set linesize 200
set pagesize 1000
set time on
set timing on
col owner for a10
col segment_name for a30
col index_name for a30
col table_name for a ......

Oracle×Ö·û¼¯


      ºÜ¶àÈ˶¼Åöµ½¹ýÒòΪ×Ö·û¼¯²»Í¬¶øÊ¹Êý¾Ýµ¼Èëʧ°ÜµÄÇé¿ö¡£ÕâÉæ¼°Èý·½ÃæµÄ×Ö·û¼¯£¬Ò»ÊÇoracel server¶ËµÄ×Ö·û¼¯£¬¶þÊÇoracle client¶ËµÄ×Ö·û¼¯;ÈýÊÇdmpÎļþµÄ×Ö·û¼¯¡£ÔÚ×öÊý¾Ýµ¼ÈëµÄʱºò£¬ÐèÒªÕâÈý¸ö×Ö·û¼¯¶¼Ò»Ö²ÅÄÜÕýÈ·µ¼Èë¡£
¡¡¡¡1¡¢²éѯoracle server¶ËµÄ×Ö·û¼¯
¡¡¡¡ÓкܶàÖÖ·½·¨¿ÉÒÔ²é³öor ......

´«ÖDz¥¿Í——Êý¾Ý¿âÖ®ORACLE£¨Ò»£©


Ò» Oracle¹«Ë¾¼ò½é 
OracleÊÇÒóÐæ³öÍÁµÄ¼×¹ÇÎÄ(oracle bone inscriptions)µÄÓ¢ÎÄ·­ÒëµÄµÚÒ»¸öµ¥´Ê
Oracle¹«Ë¾ÊÇÈ«Çò×î´óµÄÐÅÏ¢¹ÜÀíÈí¼þ¼°·þÎñ¹©Ó¦ÉÌ£¬³ÉÁ¢ÓÚ1977Ä꣬×ܲ¿Î»ÓÚÃÀ¹ú¼ÓÖÝ Redwood shore
Oracle¹«Ë¾ÒòÆä¸´ÔӵĹØÏµÊý¾Ý¿â²úÆ·¶øÎÅÃû¡£OracleµÄ¹ØÏµÊý¾Ý¿âÊÇÊÀ½çµÚÒ»¸öÖ§³ÖSQLÓïÑÔµÄÊý¾Ý¿â
OracleÔÚ³¬¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ