oracleµÄociºÍthinÇø±ð
1£©´ÓʹÓÃÉÏÀ´Ëµ£¬oci±ØÐëÔÚ¿Í»§»úÉÏ°²×°oracle¿Í»§¶Ë»ò²ÅÄÜÁ¬½Ó£¬¶øthin¾Í²»ÐèÒª£¬Òò´Ë´ÓʹÓÃÉÏÀ´½²thin»¹ÊǸü¼Ó·½±ã£¬ÕâÒ²ÊÇthin±È½Ï³£¼ûµÄÔÒò¡£
2£©ÔÀíÉÏÀ´¿´£¬thinÊÇ´¿javaʵÏÖtcp/ipµÄc/sͨѶ£»¶øoci·½Ê½,¿Í»§¶Ëͨ¹ýnative java methodµ÷ÓÃc library·ÃÎÊ·þÎñ¶Ë£¬¶øÕâ¸öc library¾ÍÊÇoci(oracle called interface)£¬Òò´ËÕâ¸öoci×ÜÊÇÐèÒªËæ×Åoracle¿Í»§¶Ë°²×°£¨´Óoracle10.1.0¿ªÊ¼£¬µ¥¶ÀÌṩOCI Instant Client£¬²»ÓÃÔÙÍêÕûµÄ°²×°client£©
3£©ËüÃÇ·Ö±ðÊDz»Í¬µÄÇý¶¯Àà±ð£¬ociÊǶþÀàÇý¶¯£¬ thinÊÇËÄÀàÇý¶¯£¬µ«ËüÃÇÔÚ¹¦ÄÜÉϲ¢ÎÞ²îÒì¡£
4£©ËäÈ»ºÜ¶àÈË˵ociµÄËٶȿìÓÚthin£¬µ«ÕÒÁË°ëÌìûÓÐÕÒµ½Ïà¹ØµÄ²âÊÔ±¨¸æ¡£
Ïà¹ØÎĵµ£º
Ç°ÃæÒ»Ö±³¢ÊÔoracleµÄÁª»ú±¸·Ý¶¼Ã»Óгɹ¦£¬³öÏÖÁË0 file(s) copied£¬½ñÌìÖÕÓÚ·¢ÏÖÁËÎÊÌâËùÔÚ£¬Ìصͼ¶µÄ´íÎó¾ÍÊÇ£¬ÔÀ´Host copyÓï¾äÒªÔÚÔËÐÐÃüÁî´°¿ÚÏÂÔËÐвŻáÉúЧ£¬Ç°ÃæÒ»Ö±¶¼Ì«Ï°¹ßÔÚpl/sqlÖнøÐвÙ×÷ÁË¡£
oracle9iÁª»ú±¸·ÝµÄ¹ý³Ì
sql>alter tablespce mytp begin backup;
sql>host copy f:\oracle\oradata\myt ......
´´½¨job
jobÊÇʲôÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶¨ ......
select s.username,
decode(l.type,'TM','TABLE LOCK',
'TX','ROW LOCK',
& ......
ת×Ô£ºhttp://hi.baidu.com/66_com
ÒýÑÔ
ÎÒÏÖÔÚËùÔÚµÄÏîÄ¿×éÐèÒª°ÑmysqlµÄÊý¾Ý´¦Àíºóµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÔÚ´ËÆÚ¼äÓöµ½ÁËÊý¾ÝÖÐÎÄÂÒÂëÎÊÌâ¡£ÏÂÃæÊÇÎÒ¶ÔÕâ¸öÎÊÌâµÄ×ܽᡣ
1¡¢linux²Ù×÷ϵͳ£¬mysql£¬oracle°²×°Ê±×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎҵĽ¨ÒéÊÇÕâÈýÕßµÄ×Ö·û¼¯±£³ÖÒ»Ö£¬È«Îªutf-8»ògdk»ògb2312¡£Èç¹ûÓÐÌØÊâÒªÇó£¬ÈýÕß²»Í¬Ò² ......
ǰЩÈÕ×ÓÕÛÌÚµÄÔÚÏßÅÄÕÕ£¬ÓÉÓÚÖ»ÊǸüÐÂblob×ֶΣ¬Ã»ÓÐÔÚ±¾µØ±£´æÕÕƬ£¬µ¼Ö¿ͻ§ÅÄÄÔÃÅÏëÒªµÄʱºò²»ÄÜÂíÉÏÄóöÀ´¡£Ã»ËµµÄËÈù˿ÍÊÇÉϵÛÄØ£¬×ö°É¡£Ê¹ÓÃÏ̳߳ش´½¨Èý¸öÏß³ÌÈÃ×Ô¶¨Ò»¸öÏß³ÌÄ¿±ê¹²Ïí£¨Ò²¾ÍÊǰѱíÀïµÄ¼Ç¼·Ö³Én×éͬʱִÐе¼³ö£©¡£³ÌÐòºÜ¼òµ¥£¬Ò»¹²ËĸöÀàºÍÒ»¸öojdbc14.jar°ü¡£ÓÉÓÚsqlÓï¾äд´íÁËÔì³É¶à¸öÏ̶߳ÔÒ»¸ ......