È«ÃæѧϰORACLE SchedulerÌØÐÔ(1)´´½¨jobs
Ëùν³öÓÚjob¶øʤÓÚjob£¬ËµµÄ¾ÍÊÇOracle 10gºóµÄÐÂÌØÐÔSchedulerÀ²¡£ÔÚ10g»·¾³ÖУ¬ORACLE½¨ÒéʹÓÃSchedulerÌæ»»ÆÕͨµÄjob£¬À´¹ÜÀíÈÎÎñµÄÖ´ÐС£Æäʵ£¬½«SchedulerÃèÊö³É¹ÜÀíjobµÄ¹¤¾ßÒѾ̫¹ýƬÃæÁË£¬10G°æ±¾ÖÐÐÂÔöµÄScheduler¾ø²»½ö½öÊÇ´´½¨ÈÎÎñÕâô¼òµ¥¡£¡£¡£¡£
Ìáʾ£ºORACLEÖйÜÀíSchedulerÊÇͨ¹ýDBMS_SCHEDULER°ü£¬±¾ÕÂÒ²ÒÔ´ËΪÇÐÈëµã£¬Í¨¹ýÏêϸ½éÉÜDBMS_SCHEDULER°üµÄʹÓã¬À´ÑÝʾÈçºÎʹÓÃScheduler¡£Ëƺõ±¾Ä©µ¹ÖÃÁË£¬Ã»¹Øϵ£¬"Èý˼±Ê¼Ç"£¬°³µÄµØÅÌ°³×öÖ÷¡£
Ò»¡¢Ê¹ÓÃJobs
¡¡¡¡ËùνJOBS£¬Æäʵ¾ÍÊÇScheduler¹ÜÀíµÄÒ»¸ö(»ò¶à¸ö)ÈÎÎñµÄÖ´Ðе÷¶È¡£
1.1 ´´½¨Jobs
¡¡¡¡Í¨¹ýDBMS_SCHEDULER°üÀ´´´½¨Jobs£¬ÊÇʹÓÃÆäCREATE_JOB¹ý³Ì¡£ÔÚ´´½¨Jobʱ£¬Óû§¿ÉÒÔÖ¸¶¨ÒªÖ´ÐеÄÈÎÎñ£¬µ÷¶ÈÐÅÏ¢(ɶʱºòÖ´ÐУ¬Ö´ÐÐÖÜÆÚ£¬ÖÕÖ¹ÈÕÆÚµÈ)ÒÔ¼°ÆäËüһЩÈÎÎñÏà¹ØµÄÊôÐÔ¡£CREATE_JOB¹ý³Ìµ÷Óû¹ÊDZȽϼòµ¥µÄ£¬ÀýÈ磺
SQL> BEGIN
2 DBMS_SCHEDULER.CREATE_JOB (
3 job_name => 'INSERT_TEST_TBL',
4 job_type => 'STORED_PROCEDURE',
5 job_action => ' P_ INSERT INTOTEST ',
6 start_date => sysdate,
7 repeat_interval => 'FREQ=DAILY;INTERVAL=1');
8 END;
9 /
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
¡¡¡¡ÊÂʵÉÏ£¬ÓÐȨÏ޵Ļ°£¬Óû§Ò²¿ÉÒÔ´´½¨ÆäËüSCHEMAϵÄJOB£¬Ö»ÐèÒªÔÚÖ¸¶¨JOB_NAMEʱ£¬°´ÕÕschema.job_nameµÄ¸ñʽ¼´¿É¡£×¢ÒâÓ´£¬ÕâÖÖÇé¿öÏ´´½¨µÄJOB£¬ÆäCREATEDÓëOWNERÓпÉÄܲ¢²»ÏàͬµÄÓ´¡£
¡¡¡¡µ±Ê¹ÓÃCREATE_JOB¹ý³Ì´´½¨JOBʱ£¬¿ÉÖ¸¶¨µÄ²ÎÊýÖµºÜ¶à£¬Ö»²»¹ý¶àÊýÇé¿öÏÂÓû§½öÖ¸¶¨²¿·Ö²ÎÊý¼´¿ÉÂú×ãÐèÇó¡£
¡¡¡¡ÆäÖУ¬ÉÏÀýÖÐÖ¸¶¨µÄ²ÎÊý£¬·Ö±ð´ú±íµÄº¬ÒåÈçÏ£º
JOB_NAME £ºÖ¸¶¨ÈÎÎñµÄÃû³Æ£¬±ØÑ¡Öµ£¬×¢ÒâҪȷ±£Ö¸¶¨µÄÃû³ÆΨһ¡£
JOB_TYPE £ºÈÎÎñÖ´ÐеIJÙ×÷ÀàÐÍ£¬±ØÑ¡Öµ£¬ÓÐÏÂÁм¸¸ö¿ÉÑ¡Öµ£º
PLSQL_BLOCK £º±íʾÈÎÎñÖ´ÐеÄÊÇÒ»¸öPL/SQLÄäÃû¿é¡£
STORED_PROCEDURE £º±íʾÈÎÎñÖ´ÐеÄÊÇORACLE¹ý³Ì(º¬PL/SQL PROCEDUREºÍJAVA PROCEDURE)£¬±¾ÀýÖÐÕýÊÇÖ¸¶¨ÕâÒ»²ÎÊýÖµ¡£
EXECUTABLE £º±íʾÈÎÎñÖ´ÐеÄÊÇÒ»¸öÍⲿ³ÌÐò£¬±ÈÈç˵²Ù×÷ϵͳÃüÁî¡£
CHAIN £º±íʾÈÎÎñÖ´ÐеÄÊÇÒ»¸öCHAIN¡£
JOB_ACTION £ºÈÎÎñÖ´ÐеIJÙ×÷£¬±ØÑ¡Öµ£¬Ó¦ÓëJOB_TYPEÀàÐÍÖÐÖ¸¶¨µÄ²ÎÊýÏàÆ¥Åä¡£
±ÈÈç˵¶ÔÓÚPL/SQLÄäÃû¿é£¬´Ë´¦¾Í¿ÉÒÔ·ÅÖÃPL/SQL¿éµÄ¾ßÌå´ú±í£¬ÀàËÆDECLARE .. BEGIN ..ENDÕâÀࣻÈç¹
Ïà¹ØÎĵµ£º
¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí
1¡¢su – oracle ²»ÊDZØÐ裬ÊʺÏÓÚûÓÐDBAÃÜÂëʱʹÓ㬿ÉÒÔ²»ÓÃÃÜÂëÀ´½øÈësqlplus½çÃæ¡£
2¡¢sqlplus /nolog »òsqlplus system/manager »ò./sqlplus system/manager@ora9i;
3¡¢SQL>connect / as sysdba ;£¨as sysoper£©»ò
connect internal/oracle AS SYSDBA ;(scott/tiger) ......
ÕÒ²»µ½ÔÌûÁË ¾ÍÌùÕâÀï°É£¡
ÔÚÏò´ó¼ÒÏêϸ½éÉÜOracle֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂOracle xmltypeÊÇʲô£¬Oracle´Ó9i¿ªÊ¼Ö§³ÖÒ»ÖÖеÄÊý¾ÝÀàÐÍ----
xmltype£¬ÓÃÓÚ´æ´¢ºÍ¹ÜÀíxmlÊý¾Ý£¬²¢ÌṩÁ˺ܶàµÄfunctions£¬ÓÃÀ´Ö±½Ó¶ÁÈ¡xmlÎĵµºÍ¹ÜÀí½Úµã¡£ÏÂÃ潫½éÉÜOracle
xmltypeµÄһЩ»ù±¾Ê¹Óá£
1.½¨Á¢º¬ÓÐOracle xmltypeÊý¾Ý ......
¾²âÊÔ£¬ÔÚOracleÖУ¬¶ÔÓÚnullºÍ¿Õ×Ö·û´®'',webMethods JDBC Adapter ²éѯ³öÀ´¶¼»áÏÔʾnull.
¶øÔÚSQL SERVERÖУ¬»á·Ö±ðÏÖʵΪnullºÍ¿Õ×Ö·û´®¡£
º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ ......
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔÀ´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔÀ´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ ......
oracle Êý¾Ý¿âµÄά»¤
¿ì¹ýÄêÁË£¬¸÷¼Ò¹«Ë¾¶¼Òª×¼±¸·Å¼ÙÁË£¬¸ø×Ô¼ºµÄÊý¾Ý¿â×ö¸öÌå¼ì°É£¬Ð´¸ö±¨¸æÖ®ÀàµÄ£¬ºÇºÇ¡£
¿´Á˸ö±ðÈËдµÄ ÏÈÄÃÀ´´æ×Å ÓпÕ×Ô¼º±à¸ö¡£
ÔØ×ÔoracleÖÐÎļ¼ÊõÂÛ̳¡£´ÓÕûÌåÉϽéÉÜÁËÒ»¸ödbaµÄÖ°ÔðºÍÈÎÎñµÈµÈ¡£¡¡¡¡
ORACLEÊý¾Ý¿â¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔORACLEÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£ ......