Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle¿ìÕÕ

 --Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
            Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
ǰ6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink_orc92_182;
Create public DATABASE LINK dblink_orc92_182 CONNECT TO bst114 IDENTIFIED BY password USING 'orc92_192.168.254.111';
--dblink_orc92_182 ÊÇdblink_name
--bst114 ÊÇ username
--password ÊÇ password
--''orc92_192.168.254.111'' ÊÇÔ¶³ÌÊý¾Ý¿âÃû
--2¡¢ÔÚÔ´ºÍÄ¿µÄÊý¾Ý¿âÉÏ´´½¨ÒªÍ¬²½µÄ±í(×îºÃÓÐÖ÷¼üÔ¼Êø,¿ìÕղſÉÒÔ¿ìËÙË¢ÐÂ)
drop table test_user;
create table test_user(id number(10) primary key,name varchar2(12),age number(3));
--3¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬²âÊÔdblink
select * from test_user@dblink_orc92_182;    //²éѯµÄÊÇÔ´Êý¾Ý¿âµÄ±í
select * from test_user;
--4¡¢ÔÚÔ´Êý¾Ý¿âÉÏ£¬´´½¨ÒªÍ¬²½±íµÄ¿ìÕÕÈÕÖ¾
Create snapshot log on test_user;
--5¡¢´´½¨¿ìÕÕ£¬ÔÚÄ¿µÄÊý¾Ý¿âÉÏ´´½¨¿ìÕÕ
Create snapshot sn_test_user as select * from test_user@dblink_orc92_182;
--6¡¢ÉèÖÿìÕÕË¢ÐÂʱ¼ä(Ö»ÄÜÑ¡ÔñÒ»ÖÖˢз½Ê½,ÍÆ¼öʹÓÿìËÙË¢ÐÂ,ÕâÑù²Å¿ÉÒÔÓô¥·¢Æ÷Ë«Ïòͬ²½)
¿ìËÙË¢ÐÂ
Alter snapshot sn_test_user refresh fast Start with sysdate next sysdate with primary key;
--oracleÂíÉÏ×Ô¶¯¿ìËÙˢУ¬ÒÔºó²»Í£µÄË¢ÐÂ,Ö»ÄÜÔÚ²âÊÔʱʹÓÃ.ÕæÊµÏîĿҪÕýȷȨºâË¢ÐÂʱ¼ä.
ÍêȫˢÐÂ
Alter snapshot sn_test_user refresh complete Start with sysdate+30/(24*60*60) next sysdate+30/(24*60*60);
--oracle×Ô¶¯ÔÚ30Ãëºó½øÐеÚÒ»´ÎÍêȫˢУ¬ÒÔºóÿ¸ô30ÃëÍêȫˢÐÂÒ»´Î
--7¡¢ÊÖ¶¯Ë¢Ð¿ìÕÕ,ÔÚûÓÐ×Ô¶¯Ë¢ÐµÄÇé¿öÏÂ,¿ÉÒÔÊÖ¶¯Ë¢Ð¿ìÕÕ.
ÊÖ¶¯Ë¢Ð·½Ê½1
begin
dbms_refresh.refresh(''sn_test_user'');
end;
ÊÖ¶¯Ë¢Ð·½Ê½2
EXEC DBMS_SNAPSHOT.REFRESH(''sn_test_user'',''F'');  //µÚÒ»¸ö²ÎÊýÊÇ¿ìÕÕÃû,µÚ¶þ¸ö²ÎÊý F ÊÇ¿ìËÙˢРC ÊÇÍêȫˢÐÂ.
--8.Ð޸ĻỰʱ¼ä¸ñʽ
ALTER SESSION SET NLS_DATE_FORMAT = ''YYYY-MM-DD HH24:MI:SS'';
--9.²é¿´¿ìÕÕ×îºóÒ»´ÎË¢ÐÂʱ¼ä
SELECT NAME,LAST_REFRESH from ALL_SNAPSHOT_REFRESH_TIMES;
--10.²é¿´¿ìÕÕÏ´ÎÖ´ÐÐʱ¼ä
select last_date,next_date,what from user_jobs o


Ïà¹ØÎĵµ£º

oracle SQLÐÔÄÜÓÅ»¯

£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......

Oracle ¾Û¼¯

¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æð£¬²¢ÇÒËüÃǾ­³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾­³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æð£¬¾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI ......

Oracle start with ... connect by prior Ó÷¨

 Óï·¨£º
select *
from ±íÃû
where Ìõ¼þ1
start with Ìõ¼þ2
connect by prior µ±Ç°±í×Ö¶Î=¼¶Áª±í×Ö¶Î
start withÓëconnect by priorÓï¾äÍê³ÉµÝ¹é¼Ç¼£¬ÐγÉÒ»¿ÃÊ÷Ðνṹ£¬Í¨³£¿ÉÒÔÔÚ¾ßÓвã´Î½á¹¹µÄ±íÖÐʹÓá£
start with±íʾ¿ªÊ¼µÄ¼Ç¼
connect by prior Ö¸¶¨Ó뵱ǰ¼Ç¼¹ØÁªÊ±µÄ×ֶιØÏµ
´úÂ룺
--´´½¨²¿Ãű ......

Oracle±í¿Õ¼äµÄ¹ÜÀí

 Oracle±í¿Õ¼äµÄ¹ÜÀí
1.´´½¨±í¿Õ¼ä
  //´´½¨ÁÙʱ±í¿Õ¼ä
 create temporary tablespace test_temp
 tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
 size 32m
 autoextend on
 next 32m maxsize 2048m
 extent management local;
&nbs ......

Oracle ¿Í»§¶ËÁ¬½Ó·þÎñÆ÷³£¼ûÎÊÌâÖ®

½ñÌì°²×°Èí¼þÒ»Ö±ÔÚ²âÊÔÁ´½Ó²»ÄÜͨ¹ý£¬³öÏÖORA-12154: TNS: could not resolve service name£¬ºóÀ´²Å·¢ÏÖÊÇtnsnames.oraÖÐÓÐÎó¡£²éÕÒÍøÉϵÄ×ÊÁÏ£¬¼Ç¼ÏÂÀ´¡£
ÒªÅųý¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÎÊÌ⣬Ê×Ïȼì²é¿Í»§¶ËÅäÖÃÊÇ·ñÕýÈ·(¿Í»§¶ËÅäÖñØÐëÓëÊý¾Ý¿â·þÎñÆ÷¶Ë¼àÌýÅäÖÃÒ»ÖÂ)£¬ÔÙ¸ù¾Ý´íÎóÌáʾ½â¾ö¡£ÏÂÃæÁгö¼¸ÖÖ³£¼ûµÄÁ¬½ÓÎÊÌâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ