¶à¸öoracleÊý¾Ý¿âÖ®¼äÊý¾Ý¹²Ïí database link
ÒòΪ¹«Ë¾µÄÕÆÉϳÇÊÐϵͳÔÚ¶à¸öµØÊÆÍ¬Ê±ÉÏÏߣ¬¶øÎªÁËÈÃÿ¸ö³ÇÊеÄ3G¿ìѶ¾ßÓеØÊÆÌØÉ«ÐÔ£¬Ã¿¸öµØÊÆÓÐ×Ô¼ºµ¥¶ÀµÄÊý¾Ý¿âϵͳ£¬¶øÃ¿¸öµØÊƵĿìѶÓÖһЩ¹²Í¬µÄ£¬Æ©ÈçͻȻ³öÁËÒ»Ìõ¹ú¼ÊÐÂÎÅ£¬ÄÇôÊDz»ÊÇÿ¸öµØÊƵĺǫ́±à¼¶¼ÒªÂ¼ÈëÒ»±é£¬ÕâÑùÎÞÒÉÊÇ×öÁËÐí¶àÎÞÓù¦£¬ËùÒÔ¹«Ë¾¿¼ÂǼÜÉèÒ»¸ö×ÜÕ¾£¬×ÜÕ¾ÉÏÓÐרÃŵÄÈ˸ºÔð£¬Ã¿Ì츺Ôð¼ÈëһЩͨÓõ쬲»¾ßÓеØÊÆÌØÉ«µÄÐÂÎÅ×ÊѶ£¬¶ø¸÷¸ö³ÇÊеÄÊý¾Ý¿â¶¼½«¹²Ïí×ÜÕ¾µÄÄÚÈÝ£¬Í¬Ê±ÓÖ¾ßÓб¾µØÌØÉ«µÄ×ÊѶ£¬Í¬Ê±½â·ÅÁËÈËÁ¦×ÊÔ´£¬¸÷¸ö³ÇÊпÉÒÔ¼¯ÖÐÓÚµØÊÆÌØÉ«µÄ½¨ÉèÉÏ¡£
ÕâÑùµÄ·½°¸£¬ÔÚ¼¼ÊõÉÏ£¬¾ÍÑݱä³ÉÁËÊý¾Ý¿âÖ®¼äµÄÊý¾Ý¹²Ïí£¬Ã¿µ±Â¼Èë×Üվ¼ÈëÊý¾ÝµÄʱºò£¬µ÷Óô¥·¢Æ÷£¬Í¨¹ýdatabaselinkÏòÆäËü¸÷¸ö·Öվͬ²½Êý¾Ý
Óõ½oracleµÄdatabase link,֮ǰҲû½Ó´¥¹ý£¬ÕâÁ½ÌìÒÀ¾Ý×ÊÁÏÃþË÷ÁËһϣ¬×ö¸ö¼Ç¼ÈçÏ£º
×÷ÓÃ:½«¶à¸öoracleÊý¾Ý¿âÂß¼ÉÏ¿´³ÉÒ»¸öÊý¾Ý¿â,Ò²¾ÍÊÇ˵ÔÚÒ»¸öÊý¾Ý¿âÖпÉÒÔ²Ù×÷ÁíÒ»¸öÊý¾Ý¿âÖеĶÔÏó¡£
Óï·¨:
CREATE [PUBLIC] DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING ‘connect_string’;
DROP [PUBLIC] DATABASE LINK dblink;
×¢Òâ:Äã±ØÐëÓÐCREATE DATABASE LINK»òCREATE PUBLIC DATABASE LINKµÄȨÏÞ£¨¿ÉÓÃsysÉí·ÝÈ¥·ÖÅ䣩,ÁíÍâ,ÔÚÄãÒªÁ¬½ÓµÄÊý¾Ý¿âÉÏ,µÄȨÏÞ.
²ÎÊý˵Ã÷:
dblink: ÄãËù´´½¨µÄdatabase linkµÄÃû×Ö,
userºÍpassword:ÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÓû§ÃûºÍÃÜÂë
connect_string:¿ÉÒÔÊǾ¹ýNet ManagerÅäÖõÄ(tnsnames.ora)ÇÒ¾²âÊÔ¿ÉÒÔÁ¬½ÓµÄ·þÎñÃû£¬²»¹ýÒ²¿Éд³ÉÕâÖÖÐÎʽ£¬¸üÖ±½Ó£º(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =orcl) )
ʹÓÃ:
select * from mobile_type@dblink ;
UPDATE mobile_type@dblink m set m.type_name='83-6' where m.type_id =6;
¾ßÌå²½Ö裺
1¡¢ Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·,
µ±È»Ò²¿ÉÏòÏÂÃæÄÇÑùÖ±½ÓдµÄ¡£
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¨Ç°ÌáÊÇÒÑ·ÖÅäÏàӦȨÏÞ£©£¬½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
create database link wapsx
connect to WAP identified by wap
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Ïà¹ØÎĵµ£º
ÔÚoracleÖУ¬ÎÒÃÇʹÓÃin·½·¨²éѯ¼Ç¼µÄʱºò£¬Èç¹ûinºóÃæµÄ²ÎÊý¸öÊý³¬¹ý1000¸ö£¬ÄÇô»á·¢Éú´íÎó£¬ÏÂÃæµÄÕâ¸ö·½·¨¾ÍÊǽâ¾öÕâ¸öÎÊÌâµÄ£¬Ëü½«ÎÒÃǵÄÉÏǧ¸ö²ÎÊý·Ö³É¼¸×飬±£Ö¤Ã¿×éµÄ²ÎÊý¸öÊý²»³¬¹ý1000
/**
* Éú³É·ûºÏÌõ¼þµÄsqlÓï¾ä,½â¾öinÎÊÌâ
* @param sqlParam£ºÎÒÃÇÐèÒª´¦ÀíµÄ²ÎÊýµÄ×Ö·û´®¸ñʽ£¬ÀýÈ ......
ÒÔÏÂÊÇÕª×ÔOracle¹ÙÍø:
¢ñ Oracle SQL Developer ÊÇÒ»¸öÃâ·ÑµÄͼÐλ¯Êý¾Ý¿â¿ª·¢¹¤¾ß¡£Ê¹Óà SQL Developer£¬Äú¿ÉÒÔä¯ÀÀÊý¾Ý¿â¶ÔÏó¡¢ÔËÐÐ SQL Óï¾äºÍ SQL ½Å±¾£¬²¢ÇÒ»¹¿ÉÒԱ༺͵÷ÊÔ PL/SQL Óï¾ä¡£Äú»¹¿ÉÒÔÔËÐÐËùÌṩµÄÈκÎÊýÁ¿µÄ±¨±í£¬ÒÔ¼°´´½¨ºÍ±£´æÄú×Ô¼ºµÄ±¨±í¡£SQL Developer ¿ÉÒÔÌá¸ß¹¤×÷ЧÂʲ¢¼ò»¯Êý¾Ý¿â¿ª·¢ÈÎÎñ¡£ ......
²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
ÏÂÔØµ ......
¾¹ý³¤Ê±¼äѧϰOracle£¬Äã¿ÉÄÜ»áÓöµ½Oracle tnsÅäÖÃÎÊÌ⣬ÕâÀォ½éÉÜOracle tnsÅäÖÃÎÊÌâµÄ½â¾ö·½·¨¡£×î½üæ×Ű²×°OracleÊý¾Ý¿â£¬±¾À´Í¦¼òµ¥µÄ£¬¿ÉÀÏÊdzöÏÖÎÊÌ⣬×îºó×Ô¼ºÔÚÍøÉÏÕûÀíÁËһЩtns´íÎó½â¾ö·½·¨£¬Ï£Íû¶Ô³õѧÕßÓÐÒæ¡£
³£¼ûÎÊÌâ:
1¡¢ORA-12541:tns:ûÓмàÌýÆ÷£º
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í» ......
´óÖ·ÖΪÈý²¿·Ý£¬1.SQL£¬2.ERP±¾Éí£¬3.±¾»ú
1.Èç¹ûÊÇSQLµ¼³öʱ³öÏÖ£¬ÂÒÂë¿ÉÒÔͨ¹ýÐÞ¸ÄNLS_LANG£¬À´±ÜÃâÂÒÂ룬
·±ÌåÐ޸ijɣºTRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
¼òÌåÐ޸ijÉ: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Ó¢ÎľͲ»ÓÃ˵ÁË£¡£¡
2.Èç¹ûÊÇERP export ʱ³öÏÖÂÒÂ룬¿ÉÒÔͨ¹ýÉèÖÃprofileÀ´ÉèÖÃFND: NATIVE CLIENT ENC ......