Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

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

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

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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ºÅ