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 ERP¶þ´Î¿ª·¢ÒÔºó»áʹÓÃʲôÑùµÄÓïÑԺͿª·¢¹¤¾ß£¿Ê×ÏÈÎÒÃÇÀ´¿´¿´Oracle¿ª·¢¹¤¾ß²úÆ·µÄ²ßÂÔ
Oracle¿ª·¢¹¤¾ßµÄ²ßÂÔÊÇÌṩÄܹ»¿ª·¢»ùÓÚInternetÄ£ÐÍÏÂÆóÒµÓ¦ÓõÄÈí¼þ¿ª·¢¹¤¾ß£¬Òò´ËOracleÌṩÁËÁ½¸ö²¢ÐеĿª·¢¹¤¾ßÒÔ¼°ÐµĿìËÙWeb¿ª·¢¹¤¾ß£º
Ò»£¬»ùÓÚPL/SQLÓïÑÔ»·¾³µÄ´«Í³¿ ......
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 ......
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 ......
Oracle ´æ´¢¹ý³Ì·µ»Ø½á¹û¼¯Óà ref cursor ʵÏÖ¡£ÊÔÑé²½ÖèÈçÏ£º
1. ½¨Á¢ ref cursor ÀàÐͺ͹ý³Ì
CREATE OR REPLACE PACKAGE types
AS
TYPE ref_cursor IS REF CURSOR;
END;
/
CREATE TABLE STOCK_PRICES(
RIC VARCHAR(6) PRIMARY KEY,
PRICE NUMBER(7,2 ......
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøÊ¹ÓÃÁË¡£¡£¡£
Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎ ......