oracleÊý¾Ýͬ²½
oracleÊý¾Ý¿âͬ²½
ÔÚÁ½Ì¨oracleÊý¾Ý¿âÖ®¼ä²âÊԳɹ¦£¬ÏÂÃæ¾Í×ܽáһϰɣº
ÐèÇó£º
ÏÖÓÐÁ½Ì¨oracleÊý¾Ý¿â·þÎñÆ÷AºÍB(A,B¿ÉÒÔÊÇÔÚͬһÄÚÍø£¬Ò²¿ÉÒÔÊÇÔÚ»¥ÁªÍøÉϵÄÁ½Ì¨¶ÀÁ¢»úÆ÷)¡£AºÍBÀïÓж¼ÓÐtestable±í£¬½á¹¹Ò»Ñù£¬ÏÖÐèÒªµ±A¿âÖеÄtestable±í±ä»¯Ê±£¬B¿âÀïµÄtestableÒ²ÏàÓ¦±ä»¯Êý¾Ý
ÎҵĽâ¾ö·½°¸£º
ÔÚAÖн¨Á¢µ½B¿âµÄÁ´½Ó£¬È»ºó¶ÔҪͬ²½µÄ±í×öÒ»¸öͬÒåsynonym£¬×îºó½¨Ò»¸ö´¥·¢Æ÷£¬¾Í¿ÉÒÔÍê³ÉÁË¡£µ±È»£¬ÄãËùÓõĵ±Ç°µÄÓû§ÒªÓÐÏàÓ¦µÄȨÏÞÈ¥Ö´ÐÐÕâЩ²Ù×÷¡£
µ±´ÓAÏòBͬ²½Êý¾Ýʱ£¬Ó¦¸ÃÔÚAÉÏ×öËùÓеÄÉèÖÃ:
1,Ϊ±£Ö¤Á¬½Óµ½Áíһ̨Զ³Ì·þÎñÆ÷µÄÊý¾Ý¿â£¬ÄãÐèÒª½¨Á¢Ò»¸öDB Link£¬µ«ÊÇ£¬ÕâÀïҪעÒâÓï·¨¸ñʽ£¬using +"connect string"£¬Õâ¸öconnect stringÓ¦¸ÃÊÇ´æÔÚÓÚoracle·þÎñÆ÷µÄTNSNAMES.ORAÎļþÀ¼àÌý³ÌÐò½«´ÓÕâÀï»ñȡԶ·½·þÎñÆ÷
µÄipµØÖ·µÈÐÅÏ¢,ÎÒ¶¨ÒåÁËÒ»¸ö'251'µÄconnect stringÈçÏÂ:
251 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mychoice)
)
)
°ÑËü´æµ½ÄãµÄTNSNAMES.ORAÎļþÀï¡£
2,È»ºó¾Í¿ÉÒÔ¶¨ÒåDB LinkÁË£º
create public database link TEST2.US.ORACLE.COM
connect to Óû§Ãû
identified by "ÃÜÂë"
using '251';
3,½¨Á¢synonym(ͬÒå)
create or replace synonym TEST01
for MYCHOICE.TESTABLE@TEST2.US.ORACLE.COM;
½¨Á¢ÍêÁËÒÔºó£¬Äã¿ÉÒÔͨ¹ý:
select * from test01
ÉÏÃæµÄÓï¾äÏ൱ÓÚÔÚB·þÎñÆ÷ÉÏÖ´ÐУº
select * from testable¡¡
£´£¬·â½¨´¥·¢Æ÷£º
µ±AÖеÄtestable±í±ä»¯Ê±£¨ÕâÀïÖ»¿¼ÂDzåÈë²Ù×÷£©£¬¾Í»á´¥·¢ÏòÔ¶³ÌµÄB¿âµÄtestableÒ²²åÈëÏàÓ¦µÄÊý¾Ý£º
create or replace trigger rtest
after insert on testable
for each row
begin
insert into test01 (something) values (:new.something);
end;
ok,ÏÖÔÚÎÒÃÇ¿ÉÒÔ²âÊÔһϣ¬ÄãÔÚ£Á¿âÖÐÍùtestable±íÖвåÈëÒ»Ìõ¼Ç¼£¬¿´¿´£Â¿âÖÐÊDz»ÊÇÒ²ÏàÓ¦µÄÔö¼ÓÁË
ÔÎÄ:http://www.cnblogs.com/wesleynet/archive/2009/04/09/1432767.html
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1¡¢²é¿´Êý¾Ý¿â×Ö·û¼¯
Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯select * from nls_database_parameters£¬ÆäÀ´Ô´ÓÚprops$£¬ÊDZíʾÊý¾Ý¿âµÄ×Ö·û¼¯¡£
¡¡¡¡
¡¡¡¡¿Í»§¶Ë×Ö·û¼¯»·¾³select * from nls_instance_parameters,ÆäÀ´Ô´ÓÚv$parameter£¬
¡¡¡¡
¡¡¡¡±íʾ¿Í»§¶ËµÄ×Ö·û¼¯µÄÉèÖ㬿ÉÄÜÊDzÎÊýÎļþ£¬»·¾³±äÁ¿»òÕßÊÇ×¢²á±í
¡¡¡¡
¡¡¡¡»á»°×Ö·û¼¯» ......
crsctl stop crs
killall init.crsd
cd /etc/init.d
rm -rf init.crs init.crsd init.cssd init.evmd
rm -rf /tmp/.oracle/
rm -rf /var/tmp/
rm -rf /var/tmp/.oracle/
cd /etc
rm -rf oraInst.loc oracle/ oratab
rm -rf $ORACLE_BASE
dd if=/dev/zero of=/dev/raw/raw_voting_disks bs=1024k
dd if=/dev/zero ......
Ò»¸öÏîÄ¿ÐèÒªDB2£¬ÒÔǰûÓùý£¬ÓÃÁËWINDOWS 2008ϵÄDB29.7 ºÃ¼¸ÖÜ£¬ËãÈëÃÅÁ˰ɣ¬ÏÂÃæÕâÎÄÕ¾͵±Ò»¸öORACLEʹÓÃÕßÑÛÀïµÄDB2µÄÓ¡Ïó°É£¬Ò²ÐíÓÐЩ¶«Î÷¿ÉÄÜÓÐÆ«²î£¬µ«ÊǾÍÊÇÎÒ×Ô¼ºµÄÓ¡Ïó£º
1¡¢Ìåϵ½á¹¹£¬DB2µÄʵÀýºÍÊý¾Ý¿â·Ö¿ªµÄ×ö·¨£¬ÎÒ¸öÈË»¹ÊDZȽÏϲ»¶µÄ£¬ÒòΪʵÀý¿ÉÒÔ´´½¨¶à¸ö£¬Êý¾Ý¿âµÄ»Ö¸´Ö±½Ó»Ö¸´µ½ÊµÀýϾͿÉÒÔÁË£¬Ïà¶ ......