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
Ïà¹ØÎĵµ£º
ÈçͼËùʾ£¬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£©ÓëÊý¾Ý¿â¡£ÊµÀýÓÉ´æ´¢½á¹¹º ......
ÏÂÃæÎÒÃÇÀ´Ñ§Ï°ÔõôÔÚLinux»·¾³Ï´´½¨Ò»¸öÐÂÊý¾Ý¿â¡£
Ò»¡¢Database Configuration Assistant£¨DBCA£©´´½¨Êý¾Ý¿â
1¡¢ÒÔOracleÓû§µÇ¼µ½Linuxϵͳ¡£
2¡¢¸ÄÏÂÏÔʾ±àÂë°É£¬Òª²»È»³öÏÖµÄÌáʾ¿ò½çÃæ»áºÍOracle°²×°Ê±ºòÒ»Ñù¡£¸Ä±àÂëÃüÁ
?[Copy to clipboard]View Code BASH
$ LANG="en_US"
3¡¢ÓÉÓÚÏÈǰÎÒÃÇÒѾ°Ñ»·¾³±ä ......
ÊÖ¶¯½¨¿âÆäʵҲ¿ÉÒÔ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊDz»Ê¹ÓÃOMF´´½¨£¬ÁíÒ»ÖÖÊÇʹÓÃOMF´´½¨¡£
Ò»¡¢²»Ê¹ÓÃOMFÊÖ¶¯´´½¨Êý¾Ý¿â
1¡¢´´½¨Îļþ¼Ð¡££¨¸ù¾Ý¸Õ²Å/ora01/db/oracle/admin/ocpÖеÄĿ¼£¬ÎÒÃÇҲͬÑù´´½¨£©
?[Copy to clipboard]View Code BASH
$ mkdir /ora01/db/oracle/admin/mydb
$ cd /ora01/db/oracle/admin/mydb
$ mkdir bdum ......
1¡¢Oracle NetÓëͨÐÅÐÒé¼ò½é
OracleµÄÍøÂçÖ§³Ö±»ÏÞÖÆÓÚTCP¡¢ÃüÃû¹ÜµÀ£¨Named Pipes£¬¼òдSDP£©¡£ËùÓеIJÙ×÷ϵͳ¶¼¾ßÓÐÒ»¸ö±¾²Ù×÷ϵͳרÓеĽø³Ì¼äͨÐÅ£¨Inter-Process Communication£¬¼òдIPC£©ÐÒé¡£
2¡¢½¨Á¢»á»°
ͨ¹ýÓû§½ø³Ì½¨Á¢Õë¶ÔʵÀýµÄ»á»°£¬¿ÉÒÔÖ´ÐУº
?[Copy to clipboard]View Code SQL
SQL> connect s ......