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

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µÄË÷ÒýÀàÐÍ


Âß¼­ÉÏ£º
Single column µ¥ÐÐË÷Òý
Concatenated ¶àÐÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ·Ç·ÖÇøË÷Òý
B-tree£º
Normal Õý³£ÐÍBÊ÷
Rever Key ·´×ªÐÍBÊ÷
Bitmap λͼË÷Òý
Ë÷Òý½á¹¹£º
B-tree£º
ÊʺÏÓë´óÁ¿µÄÔö¡ ......

OracleÈçºÎÖ´ÐÐÅúÁ¿sqlÓï¾ä

Òª´´½¨Á½¸öÎļþ
1: runBatch.bat
2: sql.txt
runBatch.bat ÄÚÈÝÈçÏ£º
sqlplus username/password @sql.txt
pause
sql.txtÄÚÈÝÈçÏ£º
spool sql.log
create table t1(cname char(20));
insert into t1(cname) values('test');
select * from t1;
spool off
exit
Ë«»÷runBatch.bat¾Í¿ÉÒÔÅúÁ¿Ö´ÐÐsql.txtÖÐ ......

oracle issue

Yes, sure ! You must be the local admin of this computer, and not a domain user.
Moreover, I'm afraid you cannot install it in a domain, maybe you should (just for testing purposes) try to install a standalone Windows system and try installing Oracle 10g on it.
You know, a RDBMS database server mu ......

Ubuntu10.04Ï°²×°Oracle 10G






<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøʹÓÃÁË¡£¡£¡£


Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ