oracleÖеÄupdateÓï¾ä¸üжà¸ö×Ö¶Î
ÎÒÔÚÒ»¸ö±íµÄtriggerÖÐÓÃupdate bill_na set a1 = 's' ,a2 ='b' where ...... µ±ÎÒ´¥·¢Õâ¸ötriggerºó a1µÄÖµ±äΪ¡®s¡¯ÔÀ´ÊÇ¡®a¡¯µ«ÊÇa2Öµ»¹'g',ÔÚwhereÌõ¼þÏ£¬ Ò²¾ÍÊÇ˵һ¸öÀ¸Î»¸üÐÂÁËÒ»¸öûÓУ¬²»ÖªµÀΪʲô£¬ÕâÑùÒ²ÄÜÌá½»Âð¡£
ÒýÓà ÎÒÔÚÒ»¸ö±íµÄtriggerÖÐÓÃupdate bill_na set a1 = 's' ,a2 ='b' where ...... µ±ÎÒ´¥·¢Õâ¸ötriggerºó a1µÄÖµ±äΪ¡®s¡¯ÔÀ´ÊÇ¡®a¡¯µ«ÊÇa2Öµ»¹'g',ÔÚwhereÌõ¼þÏ£¬ Ò²¾ÍÊÇ˵һ¸öÀ¸Î»¸üÐÂÁËÒ»¸öûÓУ¬²»ÖªµÀΪʲô£¬ÕâÑùÒ²ÄÜÌá½»Âð¡£ ÁíÒ»¸ö¿ÉÄÜÊÇ£¬Äã¸üÐÂÁË£°Ìõ¼Ç¼£¬Òª¸üÐÂa1ÁеÄÔÖµÒÔǰ¾ÍÊÇ's'¡£ ²»ºÃÒâ˼£¬²»ÊÇÎÒ¿´´íÁË£¬Ó¦¸ÃÊÇÆäËüµØ·½ÓиıäËüµÄÖµ¡£
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......