Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Á½Ì¨oracleÊý¾Ý¿âÏ໥µ¼Êý¾Ý

°¸Àý˵Ã÷£º
    ÓÐA,BÁ½Ì¨oracleÊý¾Ý¿â£¬¶¼Îª10g,ÏÖÔÚÓÐÒ»¸öAÊý¾Ý¿âÖÐone±íµÄ¼¸ÌõÊý¾ÝÒª²åÈëµ½BÊý¾Ý¿âÖеÄone±í£¿
ÔÚÍøÉϲéÔÄÁËһϣ¬¿ÉÒÔͨ¹ýÔÚAÉϽ¨Á¢dblink£¬µ±È»ÔÚB»úÉϽ¨Á¢Ò²ÊÇÒ»ÑùµÄ¡£
´ò¿ªsqlplusÖÕ¶Ë£¬»òÕßÈÎÒâµÄoracle¿Í»§¶Ë»·¾³£¬Ö´ÐÐÒÔÏÂSQL
create database link Á´½ÓÃû 
¡¡connect to Óû§Ãû identified by ÃÜÂë 
¡¡¡¡ using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ÒªÁ¬½ÓµÄIP)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = Êý¾Ý¿âµÄSID) ))';
ÀýÈ磺
create database link idtsxxzsp
¡¡connect to sxxzsp identified by sxxzsp
¡¡¡¡ using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 199.66.68.15)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = idt) ))';
½¨Á¢Á¬½ÓÖ®ºó£¬¾Í¿ÉÒÔͨ¹ý£¨±íÃû@Á´½ÓÃû£©·ÃÎʶԷ½£¨¼´ÈÎÒ»¶Ë£©µÄ±í¡£
ÀýÈç
insert into designer_form1 select * from designer_form@idtsxxzsp  //°ÑÔ¶¶ËµÄµÄdesigner_from±íÊý¾ÝÈ«²¿²åÈëµ½ÏÖÁ¬½ÓµÄÊý¾Ý¿âÖеÄdesigner_form1±íÖÐ ¡£
insert into designer_form@idtsxxzsp select * from designer_form where id in (893,892,999) //Õâ¸öÊǰѱ¾µØÊý¾ÝÓÐÑ¡ÔñµÄ²åÈëµ½Ô¶¶ËÊý¾Ý¿âÖС££¨Ö§³Ö´ó¶ÔÏó£©
ËùÒÔÕâÖÖ·½·¨¿ÉÒÔʵÏÖ°¸Àý¡£¶ÔÓÚ²»Í¬°æ±¾µÄoracleÊý¾Ý¿â£¬Ò»ÑùÊÊÓá£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE PL/SQL ´¥·¢Æ÷(trigger)ѧϰ±Ê¼Ç

1¡¢´¥·¢Æ÷µÄ¸ÅÄî
´¥·¢Æ÷Ò²ÊÇÒ»ÖÖ´øÃûµÄPL/SQL¿é¡£´¥·¢Æ÷ÀàËÆÓÚ¹ý³ÌºÍº¯Êý£¬ÒòΪËüÃǶ¼ÊÇÓµÓÐÉùÃ÷¡¢Ö´ÐкÍÒì³£´¦Àí¹ý³ÌµÄ´øÃûPL/SQL¿é¡£Óë°üÀàËÆ£¬´¥·¢Æ÷±ØÐë´æ´¢ÔÚÊý¾Ý¿âÖв¢ÇÒ²»Äܱ»¿é½øÐб¾µØ»¯ÉùÃ÷¡£
¶ÔÓÚ´¥·¢Æ÷¶øÑÔ£¬µ±´¥·¢Ê¼þ·¢ÉúµÄʱºò¾Í»áÏÔʽµØÖ´Ðиô¥·¢Æ÷£¬²¢ÇÒ´¥·¢Æ÷²»½ÓÊܲÎÊý¡£
 
´´½¨´¥·¢Æ÷µÄÓï·¨È ......

oracle ËøÎÊÌâµÄ½â¾ö

¿ÉÒÔÓÃSpotlightÈí¼þ¶ÔÊý¾Ý¿âµÄÔËÐÐ״̬½øÐÐ¼à¿Ø¡£
µ±³öÏÖsessionËøÊ±£¬ÎÒÃÇÒª¼°Ê±½øÐд¦Àí.
1. ²é¿´ÄÄЩsessionËø:
SQLÓï¾ä£ºselect 'alter system kill session '''||sid||','||serial#||''';' from v$session where sid in (select sid from v$lock where block = 1);
SQL> select 'alter system kill sessio ......

oracleÓû§È¨ÏÞ¼°½ÇÉ«

ÿ¸öOracleÓû§¶¼ÓÐÒ»¸öÃû×ֺͿÚÁî,²¢ÓµÓÐһЩÓÉÆä´´½¨µÄ±í¡¢ÊÓͼºÍÆäËû×ÊÔ´¡£Oracle½ÇÉ«£¨role£©¾ÍÊÇÒ»×éȨÏÞ£¨privilege£©(»òÕßÊÇÿ¸öÓû§¸ù¾ÝÆä״̬ºÍÌõ¼þËùÐèµÄ·ÃÎÊÀàÐÍ)¡£Óû§¿ÉÒÔ¸ø½ÇÉ«ÊÚÓè»ò¸³ÓèÖ¸¶¨µÄȨÏÞ£¬È»ºó½«½ÇÉ«¸³¸øÏàÓ¦µÄÓû§¡£Ò»¸öÓû§Ò²¿ÉÒÔÖ±½Ó¸øÆäËûÓû§ÊÚȨ¡£
Êý¾Ý¿âϵͳȨÏÞ£¨Database System Privil ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ