Flash »á±íÊý¾Ý Ö®oracle 10g
½çÃ濪·¢ÈËÔ±±¨ÓкܶàÖظ´Êý¾ÝÔÚÓû§È¨ÏÞ±í¡£È»ºóÎÒɾ³ýÁ˱íÊý¾Ýdelete ·½Ê½£¬ÐÞ¸ÄÁ˶ÔÓ¦µÄ´æ´¢¹ý³Ìʹ֮²»Öظ´£¡
ºóÀ´·¢ÏÖ ÖØÐÂÀ»ØµÄÊý¾ÝûȨÏÞ¡£ Ö»ºÃÉÁ»Øµ½½ñÌìÁ賿ÁË£¡
SQL> ALTER TABLE BA.T_POWER_ADMIN ENABLE ROW MOVEMENT;
Table altered
SQL> flashback table ba.t_Power_Admin to timestamp to_timestamp('2009-10-29 10:00:00','yyyy-mm-dd hh24:mi:ss');
flashback table ba.t_Power_Admin to timestamp to_timestamp('2009-10-29 10:00:00','yyyy-mm-dd hh24:mi:ss')
ORA-00604: µÝ¹é SQL ¼¶±ð 1 ³öÏÖ´íÎó
ORA-12801: ²¢Ðвéѯ·þÎñÆ÷ P018 Öз¢³ö´íÎóÐźÅ
ORA-01555: ¿ìÕÕ¹ý¾É: »ØÍ˶κŠ13 (Ãû³ÆΪ "_SYSSMU13$") ¹ýС
SQL> flashback table ba.t_Power_Admin to timestamp to_timestamp(2009-10-30 00:45:00','yyyy-mm-dd hh24:mi:ss');
2 ;
3 /
flashback table ba.t_Power_Admin to timestamp to_timestamp(2009-10-30 00:45:00','yyyy-mm-dd hh24:mi:ss');
;
ORA-01756: ÒýºÅÄÚµÄ×Ö·û´®Ã»ÓÐÕýÈ·½áÊø
SQL> flashback table ba.t_Power_Admin to timestamp to_timestamp('2009-10-30 00:45:00','yyyy-mm-dd hh24:mi:ss');
flashback table ba.t_Power_Admin to timestamp to_timestamp('2009-10-30 00:45:00','yyyy-mm-dd hh24:mi:ss')
ORA-00604: µÝ¹é SQL ¼¶±ð 1 ³öÏÖ´íÎó
ORA-12801: ²¢Ðвéѯ·þÎñÆ÷ P014 Öз¢³ö´íÎóÐźÅ
ORA-01555: ¿ìÕÕ¹ý¾É: »ØÍ˶κŠ12 (Ãû³ÆΪ "_SYSSMU12$") ¹ýС
SQL> flashback table ba.t_Power_Admin to timestamp to_timestamp('2009-10-30 10:45:00','yyyy-mm-dd hh24:mi:ss');
Done
SQL> execute P_GATHER_DAY_M_ADMIN;
PL/SQL procedure successfully completed
SQL>
Ïà¹ØÎĵµ£º
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡ ......
ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
2¡¢ÔÚWIN2000»òÕßwin200 ......
declare
msg varchar(1000); --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg); --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg); --Êä³ö±äÁ¿
end; ......
select decode('X','Q','±äÁ¿1','±äÁ¿2') from dual
¡¡select sysdate,to_char(sysdate,’yyyy-mm-dd hh24:mi:ss’) from dual
¡¡
¡¡select to_date(’2003-10-17 21:15:37’,’yyyy-mm-dd hh24:mi:ss’) from dual
ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷
D Ò»ÖÜÖеÄÐÇÆÚ¼¸
DAY ÌìµÄÃû ......