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

¹ØÓÚORACLE Êý¾Ý¿âѧϰµÄ¼¸µã½¨Òé

×î½üÔÚÒ»¸öÂÛ̳ÖкÍÈËÌÖÂÛÁËһͨ¹ØÓÚORACLEѧϰµÄÎÊÌ⣬½áºÏÎÒÒ²ËãÓÐ10ÄêµÄORALCE ʹÓÃѧϰµÄ¾­Àú¸ø´ó¼ÒÒ»µã½¨Òé°É¡£
1¡¢ORACLEÊý¾Ý¿âÊÇÒ»¸ö·Ç³£ÅӴ󣬷dz£¾«ÉîµÄϵͳ£¬ÒªÓг¤ÆÚ¿¹Õ½µÄ×¼±¸£¬ÄãÖ¸ÍûÄÜÔÚÒ»¸öÔÂÄÚѧ»áÈëÃÅÄÇÊÇ¿ÉÒԵģ¬µ«ÊÇÄãÒªÂò±¾24Ì쾫ͨORACLEÊý¾Ý¿âÕâÑù²»¸ºÔðÔðÈεÄÊ飬²¢Ïëͨ¹ýËûÀ´ÕÆÎÕORACLE£¬Ö»ÄÜÊdzÕÈË˵ÃΣ»
2¡¢ÎÞÂÛÄãÊdzõѧÕߣ¬»¹ÊÇÓÐÒ»¶¨²ã´ÎµÄʹÓÃÕߣ¬Ò»¶¨ÒªÑ§»á¿´ORACLEµÄÔ­³§Îĵµ£¬²¢ÇÒ²»Òªº¦Å¿´¸÷ÖÖÓ¢ÎÄ°æ±¾µÄ½Ì²Ä£¬ÊÂʵ֤Ã÷²»¶®µãÓ¢ÓïÊÇÎÞ·¨Ñ§ºÃORACLEµÄ£»
3¡¢Ò»¶¨ÒªÇ××Ô°²×°N´ÎÊý¾Ý¿â£¬²¢Ò»´Î´ÎʵÑé¸÷ÖÖ¼¼Êõ£¬¸ã±ÀÀ£Ëü£¬ÔÙ»Ö¸´Ëü£¬¾­³£µ÷Õû×Ô¼ºµÄϵͳºÍ´úÂ룬ÈÃÊý¾Ý¿âÔËÐиü¿ì£¬Äã¾Í»á´ÓÖлñÒæÁ¼¶à£»
4¡¢ÄãÒ»¶¨ÒªÑ§Ò»µã²Ù×÷ϵͳµÄ֪ʶ£¬Ò»µã´æ´¢µÄ֪ʶ£¬Ò»µãÍøÂçµÄ֪ʶ£¬ÕâÑùÄã²ÅÄܽøÒ»²½Àí½âORALCEµÄÐí¶à¶«Î÷£»
5¡¢Ò»¶¨ÒªÊìÁ·µÄÕÆÎÕSQLÓïÑÔ£¬ÈçºÎÕÆÎÕ£¬Ð´Ò»´ó¶Ñ´úÂ룬²¢²âÊÔ£¬ÎÒ¹À¼ÆÄãдÁË5ǧÐдúÂëºóÄã¾Í»áÓÐËù¸ÐÎòÁË£»
6¡¢Ò»¶¨Òª¾­³£È¥ÂÛ̳£¬¿´¿´±ðÈËÊÇÈçºÎ½â¾öÄÇЩ¾­µäORALCEÎÊÌâµÄ£¬ÊÕ¼¯±ðÈ˵ÄÓÅÐã´úÂëºÍ¾­Ñ飬Àí½âÁËÄã¾Í»á½ø²½µÄ£»
7¡¢ÔÚºÏÊʵÄʱºò£¬Ò»¶¨ÒªÑ§Ï°ORACLEµÄϵͳ¹ÜÀí£¬Ò»¸öSQL¿ª·¢ÕߺÍÒ»¸öDBAµÄ¼ÛÖµÊÇÎÞ·¨±ÈÄâµÄ£»
8¡¢Èç¹ûÓÐORACLEµÄÖ§³ÖÕʺţ¬Ò»¶¨Òª³ä·ÖÓ¦ÓÃORACLEµÄ×ÊÔ´£¬Ã»ÓÐÕʺŵĻ°£¬ORACLEµÄ¼¼ÊõÕ¾µãÒ²ÓкܶණÎ÷£¬¿ÉÒÔ¾­³£È¥²é×ÊÁÏ£»


Ïà¹ØÎĵµ£º

OracleÖÐÌí¼ÓJob

OracleÖÐÌí¼ÓJob
 --ÿ15·ÖÖÓ trunc(sysdate+1/96,'MI')/*5:Mins*/ sysdate + 5/(60*24)
SQL> variable jobno number;
SQL> begin
  2  dbms_job.submit(:jobno,'´æ´¢¹ý³ÌÃû;',sysdate,'/*1:Hr*/ sysdate + 1/24' );
  3  commit;
  4  end;
  5  /
......

Oracle Warehouse Builder 11g ʹÓÃÈëÃÅ

ÔÚ±¾½Ì³ÌÖУ¬Äú½«Ê¹ÓÃÉèÖÃÎļþÅäÖà Oracle Warehouse Builder 11g µÚ 1 °æ (OWB 11gR1) µÄÏîÄ¿»·¾³¡£È»ºó£¬Äú½«´´½¨Ò»¸ö Warehouse Builder Óû§²¢µÇ¼¡£
ËùÐèʱ¼ä
´óÔ¼ 30 ·ÖÖÓ
×¢£º OWB 11g ÉèÖýű¾µÄÏÂÔØ˵Ã÷ÔÚ±¾½Ì³ÌÉԺ󲿷ÖÌṩ¡£±¾½Ì³Ì¼°ÆäÉèÖýű¾½öÖ§³Ö OWB 11g µÚ 1 °æ¡£¸Ã Oracle ʾÀý½Ì³ÌµÄÔçÆÚ°æ±¾¿ÉÓÃÓÚ O ......

Oracle ³£ÓÃÃæÊÔÌâ

1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄ
Êý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´
²Ù×÷Ïൠ......

oracle jobºÅʹÓÃ

µ±ÓÃsubmit½¨JOBʱ£¬JOBIDÓÉϵͳ×Ô´øSEQUENCE£ºsys.JOBSEQÉú³É¡£
Èç¹ûÒ»¶Îʱ¼äºóJOBID¹ý´ó£¬¿ÉÒÔDROP SEQUENCE sys.JOBSEQ;ÔÙÖؽ¨
create sequence JOBSEQ
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20;
À´ÖØпªÊ¼JOBID¡£
¿ÉÒÔÓÃÏÂÃæÓï¾ä¸üÐÂÒѾ­½¨Á¢µÄJOBID£º
UPDATE sys.Job$
SE ......

OracleÖÐÔ¼ÊøʹÓÃ

ÒÔϼ¸ÖÖÔ¼Êø ¡¢²¢ Ò»Ò»Áо٣º
1.Ö÷¼üÔ¼Êø£º
Òª¶ÔÒ»¸öÁмÓÖ÷¼üÔ¼ÊøµÄ»°£¬ÕâÁоͱØÐëÒªÂú×ãµÄÌõ¼þ¾ÍÊÇ·Ö¿Õ
ÒòΪÖ÷¼üÔ¼Êø£º¾ÍÊǶÔÒ»¸öÁнøÐÐÁËÔ¼Êø£¬Ô¼ÊøΪ£¨·Ç¿Õ¡¢²»Öظ´£©
ÒÔÏÂÊÇ´úÂë  Òª¶ÔÒ»¸öÁмÓÖ÷¼ü£¬ÁÐÃûΪid,±íÃûΪemp
¸ñʽΪ£º
alter table ±í¸ñÃû³Æ add constraint Ô¼ÊøÃû³Æ Ôö¼ÓµÄÔ¼ÊøÀàÐÍ £¨ÁÐÃû£©
À ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ