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

oracle¼àÌýÆ÷µÄÎÊÌ⣬ÔÚÏßµÈ

ÎÒÔÚ·þÎñÄÜÕý³£µÄÆô¶¯oracle¼àÌý·þÎñ¡£µ«µ±ÎÒ´ò¿ªplsql¹¤¾ß Ñ¡ÔñÊý¾Ý¿â£¬ÊäÈëÃÜÂ룬µÇÈëµ½Êý¾Ý¿âʱ¡£³öÏÖTNSLSNR.EXE - Ó¦ÓóÌÐò´íÎ󡣡£
¿ªÊ¼ÎÒÒÔΪÊÇÎÒµÄC:\WINDOWS\system32\drivers\etc ϵÄhostÎļþ¸Ä¶¯ºóµ¼Öµģ¬ÎÒ°ÑhostÎļþµÄÄÚÈÝ»¹Ô­µ½³õʼ״̬£¬½á¹û»¹ÊÇͬÑùµÄ´íÎó

ÏÂÃæÊÇlistener.ora µÄ´úÂ룺
# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = e92b9c44e169443)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORAC)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = ORAC)
    )
  )



Çë¸ßÊÖ°ïÎÒ·ÖÎöһϣ¬Ð¡µÜÔÚ´Ëл¹ý£¡£¡
ÖØÐÂÆ


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ