oracle clob ºÍblobÎÊÌâµÄ½â¾ö
oracle clob ºÍblobÎÊÌâµÄ½â¾ö
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£»
2£ºspringÅäÖÃÈçÏ£º
java´úÂë:
<bean id="sessionFactory" >
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
</props>
</property>
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="configLocation">
<value>classpath:hibernate.cfg
Ïà¹ØÎĵµ£º
1 Éè¼Æ±í¹ý³ÌÖÐ ¾¡Á¿²ÉÓÃÊý¾ÝÇý¶¯Ë¼Ïë
±ÈÈç˵Óû§×¢²á ÒòΪҵÎñÇé¿ö ÐèÒª4¸ö×ֶβ»Í¬×éºÏÀ´±íʾÓû§´ÓÄÄÀï×¢²áµÄ¡£ ÒµÎñ²¿ÐèÒª²»¶ÏÀ©Õ¹ÐµÄÇþµÀÀ´ÕÐÀ¿Óû§£¬±ÈÈçÔÚij¸öÍøÕ¾×öÁË¹ã¸æ¡£¶ø²»ÄÜÔÚÒµÎñ³ÌÐò»ò´æ´¢¹ý³ÌÖ±½ÓÐÞ¸Ä
update f_userinfo
set f_regchannel='ÐÂÀËÊ ......
ÈçͼËùʾ£¬queryÓï¾äÖÐÈç¹ûûÓÐд \ £¬»á³öÏÖ£º
LRM-00112: ²ÎÊý 'query' ²»ÔÊÐíÓжà¸öÖµ
EXP-00019: ´¦Àí²ÎÊýʧ°Ü£¬ÓйذïÖúÇë¼üÈë 'EXP HELP=Y'
EXP-00000: µ¼³öÖÕֹʧ°Ü
exp system/system@oracledb file=d:\daochu.dmp tables=(store.jobs) query='where jobs.job like "w%"'
ÕâÑùÖ´ÐÐÈÔÈ»Èçͼʾ£¬¸ÃÔõô½â¾öÄØ£ ......
¸Ð¾õÕâ¸ö»¹ÊÇ·Ö¿ªÐ´ºÃÁË£¬Êý¾Ý¿âµÄ´´½¨¹¤×÷£¬ÔÒÔΪºÃÈÝÒ×¾ÍÊÇÏÂÒ»²½ÏÂÒ»²½µÄÎÊÌ⣬ÔÀ´ÀïÃæµÄÄÚÈÝ»¹ÊǺܶàµÄ£¬°üÀ¨Ìåϵ½á¹¹ÒªÁ˽âһЩ£¬DBCA½¨¿âÊÇÈÝÒ×À£¬²»¹ýÒª»áÊÖ¶¯½¨¿âÄDzŽпáÂÄøö½çÃæµãÏÂÒ»²½ÏÂÒ»²½Ë²»»á°¡£¬ÄÇ»¹½ÐDBA°¡£¿ºÇºÇ¡£
Oracle·þÎñÆ÷ÓÉÏÂÁÐÁ½¸öʵÌå×é³É£ºÊµÀý£¨Instance£©ÓëÊý¾Ý¿â¡£ÊµÀýÓÉ´æ´¢½á¹¹º ......
1¡¢Oracle NetÓëͨÐÅÐÒé¼ò½é
OracleµÄÍøÂçÖ§³Ö±»ÏÞÖÆÓÚTCP¡¢ÃüÃû¹ÜµÀ£¨Named Pipes£¬¼òдSDP£©¡£ËùÓеIJÙ×÷ϵͳ¶¼¾ßÓÐÒ»¸ö±¾²Ù×÷ϵͳרÓеĽø³Ì¼äͨÐÅ£¨Inter-Process Communication£¬¼òдIPC£©ÐÒé¡£
2¡¢½¨Á¢»á»°
ͨ¹ýÓû§½ø³Ì½¨Á¢Õë¶ÔʵÀýµÄ»á»°£¬¿ÉÒÔÖ´ÐУº
?[Copy to clipboard]View Code SQL
SQL> connect s ......