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 /
Ïà¹ØÎĵµ£º
´¥·¢Æ÷ÊÇÖ¸´æ·ÅÔÚÊý¾Ý¿âÖУ¬²¢±»Òþ²ØÖ´ÐеĴ洢¹ý³Ì¡£ÔÚOracle8i֮ǰ£¬Ö»ÔÊÐí»ùÓÚ±í»òÊÓͼµÄDML²Ù×÷(insert,update,delete)½¨Á¢´¥·¢Æ÷£¬ÔÚoracle8iÖ®ºó£¬²»½öÖ§³ÖDML²Ù×÷£¬Ò²ÔÊÐí»ùÓÚϵͳʼþ(Æô¶¯Êý¾Ý¿â£¬¹Ø±ÕÊý¾Ý¿â£¬µÇ¼)ºÍDDL²Ù×÷½¨Á¢´¥·¢Æ÷¡£
Ò»¡¢´¥·¢Æ÷¼ò½é
´¥·¢Æ÷ÊÇÖ¸Òþº¬Ö´ÐеĴ洢¹ý³Ì£¬Ëü¿ÉÒÔʹ ......
ÔÚÇ°ÃæÑ§Ï°OracleÊý¾Ý¿â»ù´¡¼Ü¹¹Ê±£¬ÒѾÁ˽âÁËOracleµÄ´æ´¢½á¹¹£¬Âß¼ÉÏ£¬OracleµÄÊý¾Ý´æ·ÅÔÚtablespacesÖУ¬ÎïÀíÉÏ´æ·ÅÔÚdatafilesÖС£Ò»¸ötablespaceÖ»ÄÜÊôÓÚÒ»¸öÊý¾Ý¿â(Ò»¸öÊý¾Ý¿â¿É°üÀ¨¶à¸ötablespace)£¬°üÀ¨ÁË1¸ö»ò¶à¸öÊý¾ÝÎļþ¡£Tablespace¿É½øÒ»²½·ÖΪsegments¡¢extentsºÍblocks¡£Ò»¸ödatafileÖ»ÊôÓÚÒ»¸öÊý¾Ý¿âµÄÒ» ......
£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £ ......
oracleÈçºÎ¼Ç¼Óû§µÄµÇ½ÐÅÏ¢
¿ÉÒÔ×öÒ»¸ö´¥·¢Æ÷
ÓÃÒÔϵķ½Ê½¿ÉÒÔ¼à¿ØµÇÈëµÇ³öµÄÓÃ戶:
´´½¨Ò»ÕżÇ¼µÇ¼TABLE£¬ÈçÏ£º
CREATE TABLE SYSTEM.LOGIN_LOG
(
SESSION_ID &nb ......