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£¬¿´ÊÇ·ñͨµÄ¡£¡£¡£Í¨µÄ»°£¬
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐÊ²Ã´Çø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍc ......