21±¾Oracle µç×ÓÊé
Oracle Database 11g A Beginner's Guide
Oracle Database 11g SQL
Oracle Database 11g SQL: Tuning Work Shop
Oracle Database 11g SQL: Tuning Work Shop Practices and Solutions
Oracle Essentials: Oracle Database 11g 4th Edition
Oracle Database 11g SQL Fundamentals I Exam Guide(Exam1Z0-051)
Oracle Database 11g A dministration I Exam Guide(Exam 1Z0-052)
Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)
Oracle Database 11g: ÃæÏò¹ÜÀíÔ±µÄÐÂÔö¹¦ÄÜ
Oracle Collaboration Suite Handbook
Oracle PL/SQL for DBAs
Oracle 10g Administration I Study Guide
Oracle 10g ÈëÃÅʵ¼ù
Oracle Database Foundations
Oracle Sql ±Ø±¸²Î¿¼
Oracle ±¸·ÝÓë»Ö¸´Åàѵ½Ì³Ì
Oracle 9i PL/SQL ³ÌÐòÉè¼Æ
Oracle ¾«Ëè(9i,8i,8)
Oracle 9i Êý¾Ý¿â¹ÜÀíÔ±Ö¸ÄÏ
Oracle 9i Êý¾Ý¿âϵͳÅàѵ½Ì³Ì
Oracle ר¼Ò¸ß¼¶±à³Ì
Ïà¹ØÎĵµ£º
ÕâÆªÂÛ̳ÎÄÕ£¨ÈüµÏÍø¼¼ÊõÉçÇø£©Õë¶ÔDBMS_SCHEDULERµÄʹÓ÷½·¨½øÐÐÁËÏ꾡µÄ½éÉÜ£¬¸ü¶àÄÚÈÝÇë²Î¿¼ÏÂÎÄ£º
DBMS_SCHEDULERÊÇOracle 10GÖÐÐÂÔöµÄÒ»¸ö°ü£¬ÓëÀϰ汾µÄdbms_job°üÏà±È£¬dbms_schedulerÓкܶàÐÂÌØÐÔ£¬ÎÒ½«Í¨¹ýһϵÁеÄÎÄÕÂÀ´½éÉÜÒ»ÏÂÈçºÎʹÓÃÕâ¸ö°ü.
1. ´´½¨job
job ......
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
Ç°ÃæÒ»Ö±³¢ÊÔoracleµÄÁª»ú±¸·Ý¶¼Ã»Óгɹ¦£¬³öÏÖÁË0 file(s) copied£¬½ñÌìÖÕÓÚ·¢ÏÖÁËÎÊÌâËùÔÚ£¬Ìصͼ¶µÄ´íÎó¾ÍÊÇ£¬ÔÀ´Host copyÓï¾äÒªÔÚÔËÐÐÃüÁî´°¿ÚÏÂÔËÐвŻáÉúЧ£¬Ç°ÃæÒ»Ö±¶¼Ì«Ï°¹ßÔÚpl/sqlÖнøÐвÙ×÷ÁË¡£
oracle9iÁª»ú±¸·ÝµÄ¹ý³Ì
sql>alter tablespce mytp begin backup;
sql>host copy f:\oracle\oradata\myt ......
¡¡C:\>sqlplus /nolog
¡¡¡¡SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 1ÔÂ 19 14:46:21 2005
¡¡¡¡Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
¡¡¡¡SQL> connect chanet/chanet@oradb;
¡¡¡¡ÒÑÁ¬½Ó¡£
¡¡¡¡SQL> CREATE TABLE IMAGE_LOB (T_ID VARCHAR2 (5) NOT NULL,T_IMAGE ......
select s.username,
decode(l.type,'TM','TABLE LOCK',
'TX','ROW LOCK',
& ......