¶à¸ö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 ±íɾ³ý´óÁ¿Êý¾Ýºó£¬¼´Ê¹±íÖÐÖ»Óм¸ÐмǼ£¬µ«ÓÃselect count(*) from table À´²éѯ·¢¾õ¶¼²»»áÂíÉϳöÀ´£¬ÔÒòÊǸñíµÄ¿Õ¼ä´óÁË£¬²éѯÆðÀ´ºÜÂý¡£½â¾öµÄ·½·¨ÊǰѸñíËùÕ¼Óõıí¿Õ¼äËõС£¬»òÕß˵Êͷűí¿Õ¼ä¡£
alter table XXXX move; ÕâÑù´¦Àíºó¾ÍÊÍ·ÅÁ˱í¿Õ¼äÁË¡£µ«ÊÇÊͷűí¿Õ¼äºó£¬±íµÄÐкÅrowid»á·¢Éú±ä»¯£¬¶ø»ùÓÚ ......
oracleÆô¶¯ÎÊÌâ
Ò»£ºÊý¾Ý¿âûÓÐÆô¶¯
#sqlplus /nolog
sql>connect /as sysdba
sql>startup
¶þ£º¼àÌý³öÎÊÌâ
µÇ¼DB·þÎñÆ÷
ʹÓÃlsnrctl start/stop¿ªÆô/¹Ø±Õ¼àÌý
ʹÓÃlsnrctl status²é¿´×´Ì¬
ÀíӦΪ£º
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPAP)(PORT=1521)))
STATUS of the ......
²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
ÏÂÔØµ ......
OracleµÄÈÕÆÚº¯Êý
³£ÓÃÈÕÆÚÐͺ¯Êý
1¡£Sysdate µ±Ç°ÈÕÆÚºÍʱ¼ä
SQL> Select sysdate from dual;
SYSDATE
----------
21-6ÔÂ -05
2¡£Last_day ±¾ÔÂ×îºóÒ»Ìì
SQL> Select last_day(sysdate) from dual;
LAST_DAY(S ......
Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ
Á¬½ÓOracleµÄHibernateÅäÖÃÎļþÓÐÁ½ÖÖ¸ñʽ£¬Ò»ÖÖÊÇxml¸ñʽµÄ£¬ÁíÒ»ÖÖÊÇJavaÊôÐÔÎļþ¸ñʽµÄ¡£ÏÂÃæ·Ö±ð¸ø³öÕâÁ½ÖÖ¸ñʽÅäÖÃÎļþµÄ´úÂë¡£
1£®xml¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.cfg.xmlµÄ´úÂë¡£
Àý³Ì2-5£º¹âÅÌ\mr ......