ORACLE¿çÊý¾Ý¿â²Ù×÷£¬DBLINKµÄʹÓÃ
	
    
    
	
ǰ¼¸Ìì°ïÒ»¸öÅóÓÑŪORACLE¿çÊý¾Ý¿âµÄ²Ù×÷£¬¹²ÏíϾßÌåµÄ²Ù×÷Á÷³Ì£º
Ò»¡¢²»Í¬IPµÄÊý¾Ý¿â£¨DBLINK£©
±¾µØÊý¾Ý¿âip 10.56.7.26
Ô¶³ÌÊý¾Ý¿âip 233.215.219.8
1.ÔÚ10.56.7.26Êý¾Ý¿â°²×°ÎļþÖУ¬ÕÒµ½$ORACLE_HOME/network/admin/tnsnames.oraÎļþ£¬
ĩβÌí¼Ó
MEDIADBLINK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 233.215.219.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
2.µÇ¼µ½10.56.7.26Êý¾Ý¿â£¬´´½¨database link£¬ÕâÀïÐèҪʹÓÃsysdbaµÄ½ÇÉ«µÇ¼£¬½øÐÐȨÏÞ·ÖÅä·½¿É´´½¨
Ö´ÐÐÈçÏÂsqlÓï¾ä£º
create public database link MEDIADB
  connect to smsuser identified by zonefree2better
using 'MEDIADBLINK';
´´½¨ÍêºóʹÓÃ,¼ì²éÊÇ·ñ³É¹¦£º
select owner,object_name from dba_objects where object_type='DATABASE LINK';
3.ÔÚ10.56.7.26Öд´½¨´¥·¢Æ÷
´¥·¢Æ÷ÖвåÈëÔ¶³ÌÊý¾Ý±ísql£º
create or replace trigger t_t_test
  after insert on t_sta_bill
  for each row
DECLARE
  -- local variables here
BEGIN
--²Ù×÷Ô¶³ÌÊý¾Ý±í
      INSERT INTO t_test@MEDIADB
      (USERID£¬USERNAME£¬PASSWORD)
      VALUES (:NEW.USERID,:NEW.USERNAME,:NEW.PASSWORD);
  END t_t_test;
¶þ¡¢Í¬»úÆ÷ÉϵIJ»Í¬Óû§Êý¾Ý¿â һ̨»úÆ÷ÉϵIJ»Í¬Óû§£¬¿ÉÒÔʹÓÃ
SELECT ssh2.A.* from SSH2.A, orcl.A WHERE ssh2.A.USER_ID = orcl.A.USER_ID ssh2¡¢orclΪÓû§£¬AΪÊý¾Ý±í
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ÿ¸öOracleÓû§¶¼ÓÐÒ»¸öÃû×ֺͿÚÁî,²¢ÓµÓÐһЩÓÉÆä´´½¨µÄ±í¡¢ÊÓͼºÍÆäËû×ÊÔ´¡£Oracle½ÇÉ«£¨role£©¾ÍÊÇÒ»×éȨÏÞ£¨privilege£©(»òÕßÊÇÿ¸öÓû§¸ù¾ÝÆä״̬ºÍÌõ¼þËùÐèµÄ·ÃÎÊÀàÐÍ)¡£Óû§¿ÉÒÔ¸ø½ÇÉ«ÊÚÓè»ò¸³ÓèÖ¸¶¨µÄȨÏÞ£¬È»ºó½«½ÇÉ«¸³¸øÏàÓ¦µÄÓû§¡£Ò»¸öÓû§Ò²¿ÉÒÔÖ±½Ó¸øÆäËûÓû§ÊÚȨ¡£
    Êý¾Ý¿âϵͳȨÏÞ£¨Dat ......
	
    
        
    
    ÔÚ¶ÔÊý¾Ý¿â½øÐвÙ×÷¹ý³ÌÖÐÎÒÃÇ¿ÉÄÜ»áÓöµ½ÕâÖÖÇé¿ö£¬±íÖеÄÊý¾Ý¿ÉÄÜÖØ¸´³öÏÖ£¬Ê¹ÎÒÃǶÔÊý¾Ý¿âµÄ²Ù×÷¹ý³ÌÖдøÀ´ºÜ¶àµÄ²»±ã£¬ÄÇôÔõôɾ³ýÕâÐ©ÖØ¸´Ã»ÓÐÓõÄÊý¾ÝÄØ? 
¡¡¡¡Öظ´Êý¾Ýɾ³ý¼¼Êõ¿ÉÒÔÌṩ¸ü´óµÄ±¸·ÝÈÝÁ¿£¬ÊµÏÖ¸ü³¤Ê±¼äµÄÊý¾Ý±£Áô£¬»¹ÄÜʵÏÖ±¸·ÝÊý¾ÝµÄ³ÖÐøÑéÖ¤£¬Ìá¸ßÊý¾Ý»Ö¸´·þÎñˮƽ£¬·½±ãʵÏÖÊý¾ÝÈÝÔֵȡ£ ÖØ¸´µÄÊý¾ ......
	
    
        
    
    author£ºskate
time£º2010-05-25
Êý¾ÝÎļþ¹ÜÀí
1. datafile add
2. datafile delete
3. datafile resize
4. datafile rename
1. datafile add
Ìí¼Ó±í¿Õ¼ä£¬´Ó¶øÌí¼Ódatafile
 SQL> create tablespace tbs_skate 
  2  datafile '+datagroup' size 20m;
Tablespace created
SQL>  sel ......
	
    
        
    
    ×Ö·ûº¯Êý 
ÏÂÃæÊÇOracleÖ§³ÖµÄ×Ö·ûº¯ÊýºÍËüÃǵÄMicrosoft SQL ServerµÈ¼Ûº¯Êý¡£
º¯Êý Oracle Microsoft SQL¡¡Server 
°Ñ×Ö·ûת»»ÎªASCII :ASCII ASCII 
×Ö´®Á¬½Ó: CONCAT --------------(expression + expression) 
°ÑASCIIת»»Îª×Ö·û CHR, CHAR 
·µ»Ø×Ö·û´®ÖеĿªÊ¼×Ö·û£¨×óÆð£© INSTR ,---------------CHARINDEX 
 ......
	
    
        
    
    
if %time:~,2% leq 9  (set hh=0%time:~1,1%) else  (set hh=%time:~,2%)
exp wzolerp/wzolerp@wzol file=E:\Êý¾Ý¿â±¸·Ý\wzolerp%date:~0,10%ÈÕ%hh%ʱ%time:~3,2%·Ö.dmp log=E:\Êý¾Ý¿â±¸·Ý\wzolerp%date:~0,10%ÈÕ%hh%ʱ%time:~3,2%·Ö.log
exp wzolwms/wzolwms@wzol file=E:\Êý¾Ý¿â±¸·Ý\wzolwms%date:~0,10%ÈÕ ......