¼±¼±-Oracle¼Æ»®ÈÎÎñ
SQL code:
SQL> begin
2 dbms_job.run(24);
3 end;
4 /
begin
dbms_job.run(24);
end;
ORA-12011: ÎÞ·¨Ö´ÐÐ 1 ×÷Òµ
ORA-06512: ÔÚ "SYS.DBMS_IJOB", line 406
ORA-06512: ÔÚ "SYS.DBMS_JOB", line 272
ORA-06512: ÔÚ line 2
ʲôÔÒò°¡
run Ç°ÃæµÄÄØ£¿
24 µÄJob ´´½¨³É¹¦µÄÂð£¿
²é¿´Ïà¹ØÐÅÏ¢¡¡¡¡
SQL>select JOB, NEXT_DATE, NEXT_SEC, FAILURES, BROKEN from DBA_JOBS;¡¡¡¡
ÕýÔÚÔËÐеÄJOBÏà¹ØÐÅÏ¢¡¡¡¡
select SID, r.JOB, LOG_USER, r.THIS_DATE, r.THIS_SEC from DBA_JOBS_RUNNING r, DBA_JOBS j where r.JOB = j.JOB;¡¡
ÆäʵÓÃTOAD¿´job£¬·Ç³£µÄ·½±ã..
Oracle dbms_job package Ó÷¨Ð¡½á
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4703133.aspx
24 µÄJob ´´½¨³É¹¦µÄÂð£¿
³É¹¦ÁË
°ÑÄãµÄJob Ìù³öÀ´¿´¿´£¬Äã¸øµÄÐÅϢ̫ÉÙÁË..
µÈ
SQL code:
±»Á¬½Óµ½Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
±»Á¬½ÓΪkoala
SQL>
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'proc_auto_create_table;',to_date('2009-10-22 16:10:00','yyyy-mm-dd h
Ïà¹ØÎÊ´ð£º
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
µ¼Èëpdmʱ±¨
D:\>imp ectrip_dmp/ectrip@orcl file=d:\newjzg.pdm
Import: Release 10.1.0.2.0 - Production on ÐÇÆÚÎå 9ÔÂ 11 10:29:47 2009
Copyright (c) 1982, 2004, Oracle.&nbs ......
#set Oracle User
ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂð£¿
#set Node Name
Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂð£¿
#set the Backup FileName¡¯s date
RQ=¡¯date+%F-%H-%M¡¯ ÕâÊÇÔõ ......