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
Ïà¹ØÎĵµ£º
Ò»¡¢½¨Á¢Á´½Ó·þÎñÆ÷
ÓÐÈËϲ»¶µ÷ÓÃϵͳ¹ý³ÌÀ´½¨Á¢£¬µ«ÎÒ¸öÈ˶Ôϵͳ¹ý³ÌûÓÐÌØ±ðµÄѧϰ £¬ËùÒÔÓõÄÊǽçÃæÉèÖ㬵±È»ÓÐÐËȤҲ¿ÉÒÔÑо¿Ò»Ïµģ¬ÒòΪ¿ÉÒÔ°ÑSQLÖ´Ðе¼³öÀ´¡£
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver @server = N'TEST2', @srvproduct=N'ORCL', @provider=N ......
Ë÷Òý¾Û´Ø±í
create cluster emp_dept_cluster
(deptno number(2)) size 1024;
size 1024 ±íʾÿ¸ö¾Û´Ø¼üÖµ¹ØÁª´óÔ¼1024×Ö½ÚµÄÊý¾Ý,
oracle»áÔÚÓÃÕâ¸öÊý¾Ý¿â¿éÉÏͨ¹ýsize¼ÆËã×î¶à¿ÉÒԷŶàÉÙ¸ö´Ø
Èç¹û¿éÊÇ8KB,ÄÇôÕâ¸ö¿éÉÏ×î¶à·Å7¸ö¾Û´Ø¼ü
Ïò¾Û´ØÖзÅÊý¾Ý֮ǰ,ÐèÒªÏȶԾ۴ؽ¨Á¢Ë÷Òý.
create index emp_dept_cluster_id ......
1¡¢²é¿´Êý¾Ý¿â×Ö·û¼¯
Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯select * from nls_database_parameters£¬ÆäÀ´Ô´ÓÚprops$£¬ÊDZíʾÊý¾Ý¿âµÄ×Ö·û¼¯¡£
¡¡¡¡
¡¡¡¡¿Í»§¶Ë×Ö·û¼¯»·¾³select * from nls_instance_parameters,ÆäÀ´Ô´ÓÚv$parameter£¬
¡¡¡¡
¡¡¡¡±íʾ¿Í»§¶ËµÄ×Ö·û¼¯µÄÉèÖ㬿ÉÄÜÊDzÎÊýÎļþ£¬»·¾³±äÁ¿»òÕßÊÇ×¢²á±í
¡¡¡¡
¡¡¡¡»á»°×Ö·û¼¯» ......
´ÓÉÏÖÜÆð£¬·þÎñÆ÷OracleÊý¾Ý¿â³öÏÖÎÊÌ⣬Óò»µ½°ëÌ죬¾Í»á±¨maxsession£¨150£©µÄÎÊÌ⣬¿Ï¶¨ÊÇÊý¾Ý¿âµÄ»á»°³¬¹ý×î´óÊýÁË¡£
ÓÉÓÚ·þÎñÆ÷ÅܵÄÊÇÎļþ´«ÊäÓ¦Óã¬Õ¼ÓõÄÇëÇóºÍ»á»°¿Ï¶¨ºÜ´ó£¬Òò´ËÓû§Êý²»´ó¾ÍÒѾÈÃoracleµÄ»á»°Êý´ïµ½×î´óÖµ¡£
´¦Àí·½Ê½²»ÍâºõÁ½ÖÖ£ºÀ©´óoracle×î´ósessionÊýÒÔ¼°Çå³ýinact ......
OracleÓ¦ÓÃϵͳµÄÓÅ»¯Ëĸö·½Ãæ
1.¡¡¡¡¡¡ Ó¦ÓóÌÐòSQLÓï¾äÓÅ»¯;
2.¡¡¡¡¡¡ ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû;
3.¡¡¡¡¡¡ ²Ù×÷ϵͳ²ÎÊýµ÷Õû;
4.¡¡¡¡¡¡ ÍøÂçÐÔÄܵ÷Õû.
oracleÓ¦ÓÃϵͳµÄÐÔÄÜÖ¸±ê
1.¡¡¡¡¡¡ Êý¾Ý¿âÍÌÍÂÁ¿;
2.¡¡¡¡¡¡ Êý¾Ý¿âÓû§ÏìӦʱ¼ä.
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯µÄ¼¸¸ö²¿·Ö
Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
1¡¢1¡¢µ÷Õ ......