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%"'
ÕâÑùÖ´ÐÐÈÔÈ»Èçͼʾ£¬¸ÃÔõô½â¾öÄØ£ ......
1¡¢Æô¶¯SQL*Plus
Æô¶¯ÓÃSQL*Plus¶¼»áÆô¶¯ÁË£¬ÕâÖÖ·½Ê½ºÏÊÊÕý³£µÄÖÕ¶ËÓû§Ê¹Óã¬×÷Ϊ¹ÜÀíÔ±ÎÒÃÇÓÐÁíÒ»Öֱ仯ÐÎʽNOLOG¿ª¹Ø¡£
?[Copy to clipboard]View Code BASH
$ sqlplus /nolog
2¡¢Æô¶¯iSQL*Plus
ÓÉÓÚ²»ÊÇÖ÷ҪѧÕâ¸ö£¬Ç°Ò»ÆªÒ²Ìá¹ýÕâ¸öÁË£¬¿´ÏÂǰһƪµÄÄÚÈݰɣ¬OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨ËÄ£©£º½ÓºÏOracleÊý¾Ý¿â
3¡¢Æô¶¯D ......
Ò»¡¢»ù±¾µÄOracle´æ´¢½á¹¹£º±í¿Õ¼äÓëÊý¾ÝÎļþ
OracleÊý¾Ý¿âÖоßÓÐÁ½ÖÖÀàÐ͵Ĵ洢£ºÎïÀí´æ´¢ºÍÂß¼´æ´¢¡£
ÉÏÃæµÄOracle´æ´¢½á¹¹Ä£ÐÍÖУ¬¿ÉÒÔ¿´³öÏÂÁÐÒªËØ£º
ÿ¸öÊý¾Ý¿â£¨Database£©¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¨Tablespace£©×é³É¡£Ã¿¸ö±í¿Õ¼ä¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸öÊý¾Ý¿â¡£
ÿ¸ö±í¿Õ¼ä¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ£¨Dat ......