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ΪÊý¾Ý±í
Ïà¹ØÎĵµ£º
Âß¼ÉÏ£º
Single column µ¥ÐÐË÷Òý
Concatenated ¶àÐÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ·Ç·ÖÇøË÷Òý
B-tree£º
Normal Õý³£ÐÍBÊ÷
Rever Key ·´×ªÐÍBÊ÷
Bitmap λͼË÷Òý
Ë÷Òý½á¹¹£º
B-tree£º
ÊʺÏÓë´óÁ¿µÄÔö¡ ......
Òª´´½¨Á½¸öÎļþ
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ÖÐ ......
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 ......
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøʹÓÃÁË¡£¡£¡£
Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎ ......