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

OracleµÄËø»úÖƹéÄÉ×ܽá

OracleµÄËø»úÖƹéÄÉ×ܽá
    
ËøÊÇ·ÀÖ¹ÔÚÁ½¸öÊÂÎñ²Ù×÷ͬһ¸öÊý¾ÝÔ´£¨±í»òÐУ©Ê±½»»¥ÆÆ»µÊý¾ÝµÄÒ»ÖÖ»úÖÆ¡£Oracle²ÉÓ÷âËø¼¼Êõ±£Ö¤²¢·¢²Ù×÷µÄ¿É´®ÐÐÐÔ¡£OracleµÄËø·ÖΪÁ½´ó
ÀࣺÊý¾ÝËø£¨Ò²³ÆDMLËø£©ºÍ×ÖµäËø¡£×ÖµäËøÊÇOracle
DBMSÄÚ²¿ÓÃÓÚ¶Ô×Öµä±íµÄ·âËø¡£×ÖµäËø°üÀ¨Óï·¨·ÖÎöËøºÍDDLËø£¬ÓÉDBMSÔÚ±ØÒªµÄʱºò×Ô¶¯¼ÓËøºÍÊÍ·ÅËø£¬Óû§ÎÞ»ú¿ØÖÆ¡£
OracleÖ÷ÒªÌṩÁË5ÖÖÊý¾ÝËø£º¹²ÏíËø£¨Share Table Lock£¬¼ò³ÆSËø£©¡¢ÅÅËüËø£¨Exclusive Table
Lock£¬¼ò³ÆXËø£©¡¢Ðм¶Ëø£¨Row Share Table Lock£¬¼ò³ÆRSËø£©¡¢Ðм¶ÅÅËüËø£¨Row Exclusive Table
Lock£¬¼ò³ÆRXËø£©ºÍ¹²ÏíÐм¶ÅÅËüËø£¨Share Row Exclusive Table
Lock£¬¼ò³ÆSRXËø£©¡£Æä·âËøÁ£¶È°üÀ¨Ðм¶ºÍ±í¼¶¡£
1. ¹²ÏíËø£¨Share Table Lock£¬S£©£º
¼ÓËøÓï·¨£ºLock Table TableName In Share Mode;
ÔÊÐíµÄ²Ù×÷£ºÒ»¸ö¹²ÏíËøÓÉÒ»¸öÊÂÎñ¿ØÖÆ£¬½öÔÊÐíÆäËüÊÂÎñ²éѯ±»Ëø¶¨µÄ±í¡£Ò»¸öÓÐЧµÄ¹²ÏíËøÃ÷È·µØÓÃSelect … For
updateÐÎʽËø¶¨ÐУ¬»òÖ´ÐÐLock Table TableName In Share
ModeÓï·¨Ëø¶¨Õû¸ö±í£¬²»ÔÊÐí±»ÆäËüÊÂÎñ¸üС£ÔÊÐí¶à¸öÊÂÎñÔÚͬһ¸ö±íÉϼӹ²ÏíËø£¬ÕâÖÖÇé¿öϲ»ÔÊÐíÔڸñíÉϼÓËøµÄÊÂÎñ¸üÐÂ±í£¨¼´Ê¹ÓÐÒ»¸öÊÂÎñ¿ØÖƵÄÊÇ
ÐÎÈçSelect Row … for
updateÕâÑùÐÐËøÒ²ÊDz»±»ÔÊÐíµÄ£©¡£Òò´Ë£¬½öÓÐÒ»¸öÊÂÎñµÄÒ»¸ö¹²ÏíËø¿ÉÒÔ¸üиñíÈç¹ûÆäËüÊÂÎñÒ²ÓÐÏàͬµÄÊÂÎñÔڸñíÉϵĻ°¡£
½ûÖ¹µÄ²Ù×÷£ºÒ»¸ö¹²ÏíËøÓÉÒ»¸öÊÂÎñÀ´¿ØÖÆ£¬·ÀÖ¹ÆäËüÊÂÎñ¸üиñí»òÖ´ÐÐÏÂÃæµÄÓï¾ä£º
LOCK TABLE TableName IN SHARE ROW EXCLUSIVE MODE;
LOCK TABLE TableName IN ROW EXCLUSIVE MODE;
2. ÅÅËüËø£¨Exclusive Table Lock£¬X£©£º
ÅÅËüËøÊÇÔÚËø»úÖÆÖÐÏÞÖÆ×î¶àµÄÒ»ÖÖËøÀàÐÍ£¬ÔÊÐí¼ÓÅÅËüËøµÄÊÂÎñ¶À×Ô¿ØÖƶԱíµÄдȨÏÞ¡£
¼ÓËøÓï·¨£ºLock Table TableName In Exclusive Mode;
ÔÊÐíµÄ²Ù×÷£ºÔÚÒ»¸ö±íÖÐÖ»ÄÜÓÐÒ»¸öÊÂÎñ¶Ô¸Ã±íʵÐÐÅÅËüËø£¬ÅÅËüËø½öÔÊÐíÆäËüµÄÊÂÎñ²éѯ¸Ã±í¡£
½ûÖ¹µÄ²Ù×÷£ºÓµÓÐÅÅÍâËøµÄÊÂÎñ½ûÖ¹ÆäËüÊÂÎñÖ´ÐÐÆäËüÈκÎDMLÀàÐ͵ÄÓï¾ä»òÔڸñíÉϼÓÈκÎÆäËüÀàÐ͵ÄËø¡£
¶¨ÒåÅÅËüËøµÄÓï·¨£º
LOCK TABLE TableName IN EXCLUSIVE MODE;
3. Ðм¶Ëø£¨Row Share Table Lock£¬RS£©£º
Ò»¸öÐм¶Ëø£¨ÓÐʱ³ÆΪSubshare Table Lock£¬¼ò³ÆSS£¬×Ó¹²ÏíËø£©ÐèÒª¸ÃÊÂÎñÔÚ±»Ëø¶¨ÐеıíÉÏÓÃupdateµÄÐÎʽ¼ÓËø¡£µ±ÓÐÏÂÃæÓï¾ä±»Ö´ÐеÄʱºòÐм¶Ëø×Ô¶¯¼ÓÔÚ²Ù×÷µÄ±íÉÏ¡£
SELECT . . . from TableName. . . FOR U


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle EBS ÈçºÎÔ½áÖ®Ó¦¸¶(AP)¶ÔÕËÏê½â

Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑ­ÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......

Oracle³£¼û´íÎó——ORA 00942


¸ù¾ÝǰЩÌìΪij´ó·É»ú¹«Ë¾µ¼Èëij´ó·É»úÉú²úÊý¾ÝµÄ¾­Àú£¬×¼±¸Ð´Æª¹ØÓÚOracleµ¼³öÎļþDMP¸ñʽµÄ·ÖÎö£¬½á¹ûÔÚ±¾»úµ¼³öÒ»×éÑÝʾÊý¾Ýʱºò£¬³öÏÖÁË´íÎó£¬Ë³±ã½â¾öÏ¡£
±¾»ú×°µÄÊÇOracle 11g 32bit(11.0.6)µÄClient£¬Ö÷ÒªÊÇΪÁËʹÓÃODT.Net 11.0.6.21£¬Ö§³ÖVS2008¡£µ«ÊDzÉÓÃEXPÃüÁîµ¼³öÊý¾Ý¿âµÄʱºò£¬³öÏÖÁËЩ¹îÒìµÄ´íÎó¡£
Ö´Ð ......

Oracle³£¼û´íÎó——TNS 01150

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS ......

¹â»·¾¡Ê§ OracleÔÚÖйúÈ«ÃæÔâÓö¡°»¬Ìú¬¡±

 
¼Ì9Ô·ݹúÄÚijÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ