oracle ¶¨Ê± ×÷Òµ Àý×Ó
sql > variable jobno number ;
sql > begin
sql > DBMS_JOB.submit(:jobno, ' pro_name(); ' ,sysdate, ' sysdate+1 ' );
dbms_job.submit(:job1, ' MYPROC; ' ,sysdate, ' sysdate+1/1440 ' );¡¡¡¡ -- ÿÌì1440·ÖÖÓ£¬¼´Ò»·ÖÖÓÔËÐÐtest¹ý³ÌÒ»´Î
sql > commit ;
sql > end ;
------------------------------------
ÔÚÃüÁî¿ØÖÆ̨ÖÐÕâÑù¾Í¿ÉÒÔ½¨²úÒ»¸ö×÷ÒµÁË¡£sysdate±íʾµ±Ç°×÷Òµ½«À´Ö´ÐеÄʱ¼ä£¬sysdate+1±íʾµ÷ÓÃƵÂÊ¡£
ÃèÊö INTERVAL²ÎÊýÖµ
ÿÌìÎçÒ¹12µã 'TRUNC(SYSDATE + 1)'
ÿÌìÔçÉÏ8µã30·Ö 'TRUNC(SYSDATE + 1) + £¨8*60+30£©/(24*60)'
ÿÐÇÆÚ¶þÖÐÎç12µã 'NEXT_DAY(TRUNC(SYSDATE ), ''TUESDAY'' ) + 12/24'
ÿ¸öÔµÚÒ»ÌìµÄÎçÒ¹12µã 'TRUNC(LAST_DAY(SYSDATE ) + 1)'
ÿ¸ö¼¾¶È×îºóÒ»ÌìµÄÍíÉÏ11µã 'TRUNC(ADD_MONTHS(SYSDATE + 2/24, 3 ), 'Q' ) -1/24'
ÿÐÇÆÚÁùºÍÈÕÔçÉÏ6µã10·Ö 'TRUNC(LEAST(NEXT_DAY(SYSDATE, ''SATURDAY"), NEXT_DAY(SYSDATE, "SUNDAY"))) + £¨6×60+10£©/£¨24×60£©'
select * from user_jobs
²éѯ×÷Òµ¼Ç¼
1£®È·±£OracleµÄ¹¤×÷ģʽÔÊÐíÆô¶¯ÈÎÎñ¶ÓÁйÜÀíÆ÷
Oracle¶¨Ê±Ö´ÐГJob Queue”µÄºǫ́³ÌÐòÊÇSNP½ø³Ì£¬¶øÒªÆô¶¯SNP½ø³Ì£¬Ê×ÏÈҪȷ±£Õû¸öϵͳµÄģʽÊÇ¿ÉÒÔÆô¶¯SNP½ø³ÌµÄ£¬ÕâÐèÒªÒÔDBAµÄÉí·ÝÈ¥Ö´ÐÐÈçÏÂÃüÁ
svrmgrl>; alter system enable restricted session;
»òsql>; alter system disenable restricted session;
ÀûÓÃÈçÉÏÃüÁî¸ü¸ÄϵͳµÄ»á»°·½Ê½Îªdisenable restricted£¬ÎªSNPµÄÆô¶¯´´ÔìÌõ¼þ¡£
2£®È·±£OracleµÄϵͳÒѾÅäÖÃÁËÈÎÎñ¶ÓÁйÜÀíÆ÷µÄÆô¶¯²ÎÊý
SNPµÄÆô¶¯²ÎÊýλÓÚOracleµÄ³õʼ»¯ÎļþÖУ¬¸ÃÎļþ·ÅÔÚ¡
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£
ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS(ÃüÁîÐÐ)ÖÐÖ´ÐУ¬DOSÖ ......
Ò»¡¢²ÎÊýÉèÖÃ
--1¡¢ÉèÖÃA£º
db_block_size = 8192
db_domain = ''
db_file_multiblock_read_count = 16
db_name = bidata
db_recovery_file_dest = /export/home/app/oracle/oracle/product/10.2.0/db_1/flash_recovery_area
db_recovery_file_dest_size = 10737418240
dispatchers = '(PROTOCOL=TCP) (SERVICE=b ......
Oracle Óû§¼°½ÇÉ« ½éÉÜ ÊÕ²Ø
Ò». Óû§¹ÜÀí
1.1 ½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE USER DAVE IDENTIFIED BY pwd
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp ......
£±¡¢È·¶¨ÄãµÄ¼ÆËã»úÉÏ×°ÓÐoracleµÄ¿Í»§¶Ë£¬Èç¹ûûÓУ¬Çë°²×°oracle¿Í»§¶Ë
£²¡¢È·¶¨ÓÐÄãµÄoracle·þÎñÀïÓÐÄãÒªÐèÒª±¸·ÝµÄÊý¾Ý¿âµÄ·þÎñÃû¡£
£³¡¢ÖÆ×÷Ò»¸öÅú´¦ÀíÎļþ£¨oracleBackup.bat£©£¬¾ßÌå·½·¨£º´ò¿ª“¼Çʱ¾”£¬±£´æΪoracleBackup.bat£¬
¡¡¡¡´Ëʱ±£´æµÄÎļþÀàÐÍÑ¡ÔñΪ“ËùÓÐÎļþ”¡£Îҵı£´æÄ¿Â ......