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
Ïà¹ØÎĵµ£º
ÏÂÃæÎÒÃÇÀ´Ñ§Ï°ÔõôÔÚLinux»·¾³Ï´´½¨Ò»¸öÐÂÊý¾Ý¿â¡£
Ò»¡¢Database Configuration Assistant£¨DBCA£©´´½¨Êý¾Ý¿â
1¡¢ÒÔOracleÓû§µÇ¼µ½Linuxϵͳ¡£
2¡¢¸ÄÏÂÏÔʾ±àÂë°É£¬Òª²»È»³öÏÖµÄÌáʾ¿ò½çÃæ»áºÍOracle°²×°Ê±ºòÒ»Ñù¡£¸Ä±àÂëÃüÁ
?[Copy to clipboard]View Code BASH
$ LANG="en_US"
3¡¢ÓÉÓÚÏÈǰÎÒÃÇÒѾ°Ñ»·¾³±ä ......
1¡¢Æô¶¯SQL*Plus
Æô¶¯ÓÃSQL*Plus¶¼»áÆô¶¯ÁË£¬ÕâÖÖ·½Ê½ºÏÊÊÕý³£µÄÖÕ¶ËÓû§Ê¹Óã¬×÷Ϊ¹ÜÀíÔ±ÎÒÃÇÓÐÁíÒ»Öֱ仯ÐÎʽNOLOG¿ª¹Ø¡£
?[Copy to clipboard]View Code BASH
$ sqlplus /nolog
2¡¢Æô¶¯iSQL*Plus
ÓÉÓÚ²»ÊÇÖ÷ҪѧÕâ¸ö£¬Ç°Ò»ÆªÒ²Ìá¹ýÕâ¸öÁË£¬¿´ÏÂǰһƪµÄÄÚÈݰɣ¬OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨ËÄ£©£º½ÓºÏOracleÊý¾Ý¿â
3¡¢Æô¶¯D ......
OracleÈëÃÅÊé¼®ÍÆ¼ö
ºÜ¶àÅóÓÑÒªÎÒ°ïÃ¦ÍÆ¼öÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²á ......
1¡¢µ÷ÕûĬÈϵݲȫÉèÖÃ
1.1¡¢Ä¬ÈϵÄÓû§
²é¿´Êý¾Ý¿âµÄÓû§ºÍ״̬£¬¿ÉÒÔ²éѯDBA_USERSÊÓͼ¡£
?[Copy to clipboard]View Code SQL
SQL> select username,account_status from dba_users;
1.2¡¢PUBLICȨÏÞ
OracleÖдæÔÚÒ»¸öÃûΪPUBLICµÄαÓû§¡£Ö»ÒªÓÃPUBLICÊÚÓèij¸öȨÏÞ£¬ÄÇôËùÓÐÓû§¶¼»á±»ÊÚÓèÕâ¸öȨÏÞ¡£
?[Copy ......
1¡¢»Ö¸´½á¹¹Óë½ø³Ì
ÔÚ½éÖÊʧ°Üºó£¬¸ù¾ÝÊÜËðÎļþµÄÀàÐÍ£¬´æÔÚ²»Í¬µÄ»Ö¸´·½·¨¡£Êý¾Ý¿âÓÉ¿ØÖÆÎļþ¡¢Áª»úÖØ×öÈÕÖ¾ÎļþÒÔ¼°Êý¾ÝÎļþ×é³É¡£Èç¹û¸´ÓÃÁË¿ØÖÆÎļþ»òÁª»úÖØ×öÈÕÖ¾Îļþ£¬ÄÇô»Ö¸´ÊÜËðµÄÕâЩÎļþÊ®·ÖÈÝÒס£
¶ÔÓÚÊÜËðµÄ¿ØÖÆÎļþ£¬¿ÉÒÔ½«ÆäÌæ»»ÎªÄ³¸ö¸´Óø±±¾£¬Ò²¿ÉÒÔʹÓÃCREATE CONTROLFILEÃüÁîÖØ½¨¡£
ÊÜËðµÄÁª»úÖØ×öÈ ......