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

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>


Ïà¹ØÎĵµ£º

Oracle Job Óï·¨ºÍʱ¼ä¼ä¸ôµÄÉ趨

³õʼ»¯Ïà¹Ø²ÎÊý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Êý¾Ý¿â

ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
   
  1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
    ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
   
  2¡¢ÔÚWIN2000»òÕßwin200 ......

Oracle´æ´¢¹ý³ÌµÄÖ´ÐÐ

declare
msg varchar(1000);    --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg);   --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg);   --Êä³ö±äÁ¿
end; ......

oracle to_date,to_char,trunc,decodeÓ÷¨

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 ÌìµÄÃû ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ