Oracle ¿ìÕÕ¼° dblinkʹÓà £¨Á½Ì¨·þÎñÆ÷Êý¾Ýͬ²½£©
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
-- Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
/*Ò»¡¢´´½¨dblink£º*/
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblin
drop database link dblink_anson;
Create public
database link dblink_anson
Connect to lg identified by lg using 'SDLGDB';
--Ô´Êý¾Ý¿âµÄÓû§Ãû¡¢ÃÜÂë¡¢·þÎñÆ÷Ãûk
/*¶þ¡¢´´½¨¿ìÕÕ£º*/
--1¡¢ÔÚÔ´ºÍÄ¿µÄÊý¾Ý¿âÉÏͬʱִÐÐÒ»ÏÂÓï¾ä£¬´´½¨Òª±»Í¬²½µÄ±í
drop table tb_anson;
create table tb_anson(c1 varchar2(12));
alter table tb_anson add constraint pk_anson primary key (C1);
--2¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬²âÊÔdblink
select * from tb_anson@dblink_anson;
select * from tb_anson;
--3¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨ÒªÍ¬²½±íµÄ¿ìÕÕÈÕÖ¾
Create snapshot log on tb_anson;
--4¡¢´´½¨¿ìÕÕ£¬¿ìÕÕ(±»Í¬²½£¨Ô´£©Êý¾Ý¿â·þÎñ±ØÐëÆô¶¯)
Create snapshot sn_anson as select * from tb_anson@dblink_anson;
--5¡¢ÉèÖÿìÕÕË¢ÐÂʱ¼ä
Alter snapshot anson refresh fast Start with sysdate+1/24*60 next sysdate+10/24*60;
--oracle×Ô¶¯ÔÚ1·ÖÖÓºó½øÐеÚÒ»´Î¿ìËÙˢУ¬ÒÔºóÿ¸ô10·ÖÖÓ¿ìËÙË¢ÐÂÒ»´Î
Alter snapshot anson refresh complete Start with sysdate+30/24*60*60 next sysdate+1;
--oracle×Ô¶¯ÔÚ30³®ºó½øÐеÚÒ»´ÎÍêȫˢУ¬ÒÔºóÿ¸ô1ÌìÍêȫˢÐÂÒ»´Î
--6¡¢ÊÖ¶¯Ë¢Ð¿ìÕÕ
begin
dbms_refresh.refresh('"CS"."SN_ANSON"');
end;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¡¡¡¡ÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓá£
¡¡¡¡
¡¡¡¡ÔÚ´óÐÍµÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ¹Ò²ºÜ¿ì£¬µ«ÊÇÈÔÈ»²»ÄÜÂú×ãÓû§µÄÐèÇó£¬ÎªÁË ......
####################################
# TNSNAMES.ORA Configuration File:D:\Oracle_now\NETWORK\ADMIN\tnsnames.ora ÎļþλÖÃ
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Jan 26 20:05:00 CST 2010
####################################
TEST1.TCSGEGDC.COM =
(DESCRIPTION =
& ......
oracleȨÏÞÌåϵÖÐÓиödefault role£¬±È½ÏÄÑÒÔÀí½â¡£ÏÂÃæÓÃʵÀý˵Ã÷Ò»ÏÂ×÷Óá£
ÎÒÃÇ¿ÉÒÔ¸øÄ³¸öÓû§·ÖÅäһЩ½ÇÉ«£¬±ÈÈçrole r1,r2,r3,r4£¬¶øÆäÖпÉÒÔ½«Ä³Ð©½ÇÉ«±ÈÈçr1ÉèÖÃΪdefault role£¬ÆäËûµÄ²»ÉèÖóÉdefault role£¬ÕâÑù£¬µ±¸ÃÓû§µÇ¼ʱ£¬×Ô¶¯¾ßÓÐdefault roleÖÐËù°üº¬µÄȨÏÞ£¬ÆäËûµÄ½ÇÉ«Ëù¾ßÓеÄȨÏÞҪͨ¹ýset role ½ÇÉ ......
--ɾ³ý¿ÕµÄ±í¿Õ¼ä£¬µ«ÊDz»°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name;
--ɾ³ý·Ç¿Õ±í¿Õ¼ä£¬µ«ÊDz»°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name including contents;
--ɾ³ý¿Õ±í¿Õ¼ä£¬°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name including datafiles;
--ɾ³ý·Ç¿Õ±í¿Õ¼ä£¬°üº¬ÎïÀíÎļþ
drop tablespace table ......