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

linux°²×°oracle xeÔ¶³ÌÁ¬½ÓÎÊÌâ

ÎÒÔÚһ̨ÈËradhat 5.2·þÎñÆ÷Ï°²×°ÁËÒ»¸öoracle10g xeÊý¾Ý¿â£¬±¾µØÁ¬½ÓÒ²ÊÇ¿ÉÒԵģ¬µ«ÊDz»ÖªµÀÔõôµÄ£¬ÎÒÔ¶³ÌÁ¬½ÓÄÇ̨Êý¾Ý¿â£¬×ÜÊDZ¨´í£¬ÎÒ°´ÕÕÊéÉϽ²µÄ»·¾³±äÁ¿Ê²Ã´µÄ¶¼ÉèÖúÃÁË°¡£¬¶øÕâ¸ö°æ±¾Ò²ÊÇÖ§³ÖÔ¶³ÌÊý¾Ý¿âÁ¬½ÓµÄ°¡£¬·À»ðǽÎÒÒ²¹ØÁË£¬ÕæµÄ²»ÖªµÀÄı߳öʲôÎÊÌ⣬Çë¸ßÊÖ°ï°ï棬Íò·Ö¸Ðл£¡£¡£¡

tnsnames.ora ÅäÖùýÁËû£¿

tnsping sid ÄÜ·ñpingͨ£¿


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716

tnsnames.oraÅäÖùýÁË£¬pingÒ²ÊÇ¿ÉÒÔpingͨµÄ£¬¾ÍÊDz»ÖªµÀÄı߳öµÄÎÊÌâ


°Ñ±¨µÄ´íÌù³öÀ´...


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716

´íÎó´úÂëÊÇora-12545

ÆÚ´ý¡£¡£

×Ô¼º¶¥ÏÂ

½ñÌìÓа²×°ÁËһ̨Êý¾Ý¿â£¬ÊÇÔÚred hat5.2ÏÂÃæ°²×°oracle11gµÄ£¬ÏÖÔÚ·¢ÏÖ»¹ÊÇÔ¶³ÌÁ¬½ÓÊý¾Ý¿âʵÏÖ²»ÁË£¬¶þ¥˵µÄtnsping sidÊÇÔÚ±¾µØµÄ»¹ÊÇÔÚÔ¶³Ì×öµÄ°¡£¿¸Õ¸ÕÔÚÔ¶³ÌµÄ·´Õý²»ÐУ¬´íÎóÊÇ£º
TNS-12545: ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ, Á¬½Óʧ°Ü

×Ô¼ºÔÙ¶¥ÏÂ

Ê×ÏÈ¿Í»§»úÖ±½ÓpingÊý¾Ý¿âËùÔÚÖ÷»úµÄIP£¬¿´ÊÇ·ñͨµÄ¡£¡£¡£Í¨µÄ»°£¬


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÊÇ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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

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Ò²²»¿É ......

oracleÖÐÒ»¸öSQLÓï¾äµÄÇø±ð - Oracle / »ù´¡ºÍ¹ÜÀí

OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐʲôÇø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint

ÒýÓÃ
constraintºÍc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ