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

ORACLE jobʹÓ÷½·¨

EXP/IMP×¢Ò⣺´ÓÈ«¿âÂß¼­±¸·Ý°´Óû§µ¼Èëʱ£¬OracleûÓе¼ÈëJOB£¬²»ÖªµÀÕâ¸öÊÇOracleµÄbug£¬»¹ÊǹÊÒâÕâÑùʵÏֵġ£Õâ¸öÎÊÌâÔÚµ¼ÈëµÄÓû§ÃûºÍµ¼³öµÄÓû§Ãû²»Í¬Ê±³öÏÖ£¬Èç¹ûµ¼ÈëµÄÓû§ÃûºÍµ¼³öµÄÓû§ÃûÒ»Ö£¬Ôò²»»á³öÏÖÕâ¸öÎÊÌâ¡£»³ÒÉÊÇOracleµ÷ÓÃDBMS_IJOB°üʱ³öÏÖµÄÎÊÌâ¡£
×ÜÖ®£¬EXP/IMPµÄʱºòÐèÒª¿¼ÂÇJOB£¬²¢ÔÚ²Ù×÷½áÊøºó¼ì²éJOBÐÅÏ¢ÊÇ·ñÒѾ­ÕýÈ·µÄµ¼Èë¡£
±¾Îĸø´ó¼Ò½éÉÜÒ»ÏÂORACLE jobµÄʹÓ÷½·¨£º
Õâ¸öjob Ö´ÐеŦÄÜ: ÏòijÕűíÖж¨Ê±²åÈëÒ»Ìõ¼Ç¼(±ÈÈçÒ»·ÖÖÓ²åÈëÒ»Ìõ)
step 1: Ê×ÏÈ´´½¨Ò»Õűí a,
create table a(a date);
step 2: ´´½¨Ò»¸öproc test ,Õâ¸ö test ¾ÍÊÇÈ¡³öϵͳµÄµ±Ç°Ê±¼äÖµ,È»ºó²åÈëµ½ a ±íÖÐ
SQL> create or replace procedure test as
begin
insert into a values(sysdate);
end;
/
step 3: ´´½¨Ò»¸öjob,Õâ¸öjobÉèÖÃΪÿ·ÖÖÓÔËÐÐÒ»´Î,Ò²¾ÍÊÇÿ·ÖÖÓµ÷ÓÃÒ»ÏÂÉÏÃæµÄ test,Õâ¸ö proc
SQL> variable job1 number;
SQL>
SQL> begin
dbms_job.submit(:job1,'test;',sysdate,'sysdate+1/1440');¡¡¡¡--ÿÌì1440·ÖÖÓ£¬¼´Ò»·ÖÖÓÔËÐÐtest¹ý³ÌÒ»´Î
end;
/
step 4:È¥ÔËÐÐÉÏÃæ´´½¨ºÃµÄ job
SQL> begin
dbms_job.run(:job1);
end;
/
[×¢]:¹ý¼¸·ÖÖÓºó Óà select to_char(a,'yyyy/mm/dd hh24:mi:ss')from a; È¥²é¿´ a ±í,·¢ÏÖ¶àÁ˼¸Ìõ¼þ¼Ç¼,Õâ¾Í˵Ã÷ÁË job Õý³£¹¤×÷ÁË
Èç¹ûҪɾ³ýÕâ¸ö job ¿ÉÒÔÓÃ:
SQL> begin
dbms_job.remove(:job1);
end;
/
 ×¢£ºÓÃdeclareÉùÃ÷²»ÓüÓðºÅ job ²»ÐèÒªÔÚÃüÁîÐÐÀïÃæÖ´ÐÐ


Ïà¹ØÎĵµ£º

oracleÊý¾Ý×ÖµäС½á


ÏÂÃæ°´Àà±ðÁгöһЩORACLEÓû§³£ÓÃÊý¾Ý×ÖµäµÄ²éѯʹÓ÷½·¨¡£
   
    Ò»¡¢Óû§
    ²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
    SQL>select username,default_tablespace from user_users;
    ²é¿´µ±Ç°Óû§µÄ½ÇÉ«
    SQL ......

OracleÓöµ½µÄÎÊÌâ

ÅäÖÃÐÅÏ¢Ó¦¸Ã¶¼Ã»ÓÐ´í£¬Çý¶¯Ò²·´¸´¼ÓÔØÁË£¬Ã»ÓÐÎÊÌâ
ÔËÐÐMyeclipse±àÒë¿É¹ý£¬ÔÚÍøÒ³²âÊÔʱ³öÏÖÈçÏ´íÎó£º
java.sql.SQLException: µ÷ÓÃÖÐÎÞЧµÄ²ÎÊý
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError ......

Linux(Centos5.4)Éϰ²×°oracle10gR2(10.2.1)

ÎÒÓõÄÊÇCentos5.4 DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°ÑÖ÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10gµÄʱºòÐèÒªÓõ½£¬Ã»Óа²×°µÄ°üÓÐ:
libXp-1.0.0-8.i386.rp ......

½«Java¶ÔÏó´æ´¢µ½OracleÊý¾Ý¿âÖÐ

 ¶ÔÏó³Ö¾Ã»¯£¬Ò²¾ÍÊÇ¿ÉÒÔ°ÑÕâ¸ö¶ÔÏóÓÀÔ¶µÄ±£´æÆðÀ´£¬ÕâÀïµÄ±£´æ²»½öÊǶÔÏó±¾Éí£¬»¹°üÀ¨ËûµÄÊôÐÔºÍËùÒÀÀµµÄÆäËûÀࡣͨ³££¬¶ÔÏó¿ÉÒԳ־û¯µ½Îļþ»òÕßÊÇÊý¾Ý¿âÖС£ÎÒÕâÀïÖ»½éÉÜÈçºÎ½«¶ÔÏó´æ´¢µ½Êý¾Ý¿âÖС£Ç¡ÇÉOracleÊý¾Ý¿âΪÎÒÃÇÌṩÁËÕâÑùµÄ·½±ã¡£
   ÔÚOracleÖУ¬ÓÐÒ»ÖÖblogµÄ×Ö¶ÎÀàÐÍ£¬ËüÊÇÓÃÀ´´æ´¢´óÁ¿µÄ¶ ......

Oracle×óÓÒÈ«Á¬½Ó×ܽá

--½¨Á¢²âÊÔÊý¾Ý
create table a(id number);
create table b(id number);
insert into a values(1);
insert into a values(2);
insert into a values(3);
insert into b values(1);
insert into b values(2);
insert into b values(4);
commit;
--×ó:
--Ö÷Á÷Êý¾Ý¿âͨÓõķ½·¨
select * from a left ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ