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

oracleÊý¾Ý¿âÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

tnsnames.oraÀïÃæµÄÄÚÈÝÈçÏ£º
ORACLE_192.168.1.125 =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.125)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SID = oracle)
  (SERVER = DEDICATED)
  )
  )
ÕâÊǿͻ§¶Ë·ÃÎÊ·þÎñÆ÷ʱ×Ô¶¯Éú³ÉµÄ£¬³ÌÐòÀïµÄÁ¬½Ó×Ö·û´®ÊÇ<add name="oracle_conn" connectionString="Data Source=ORACLE;User ID=qqhe;Password=qqhe;" providerName="Oracle.DataAccess.Client"/>µ÷ÊÔʱvs2010ÌáʾORA-12154: TNS: ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û£¬ÈÃÎҸе½ÒÉ»óµÄÒ»µãÊÇÁ¬½Ó´®ÀïºÃÏñûÓÐÖ¸¶¨Ê¹Ó÷þÎñÆ÷ÉϵÄÄĸöÊý¾Ý¿â£¬ÇëÎÊÊDz»ÊÇÁ¬½Ó×Ö·û´®Ð´´íÁË£¬Èç¹û´íÁËÓ¦¸ÃÔõôд£¿

ÁíÍ⣬Oracle.DataAccess.Client.OracleConnectionÓëOracleConnection£¨·ÇSystem.Data.OracleClient.OracleConnection£©ÒÔ¼°ODP.NETµ½µ×ÓÐÊ²Ã´Çø±ð»òÕßÁªÏµ£¿ÔÚϳõѧOracle.DataAccess.ClientÁ¬½Ó·½Ê½£¬Çëǰ±²ÃÇÖ¸½Ì¡£
ºÃ³¤Ê±¼äûÓÐÓÃOracleÁË£¬µ«ÊÇÒÀÏ¡ÄܼÇÒäÆðµã£¬Ï£Íû¶ÔÄãÓеã°ïÖú¡£
ÄúÔÙ¼ì²éÄãµÄÒ»¸ö¼àÌýµÄÎļþ£¬ºÃÏñ¸úÄãÉÏÃæµÄÎļþÔÚͬһ¸öĿ¼¡£ÕâÁ½¸öÎļþŪÃ÷°×ÁË£¬Äã¿ÉÒÔËæÒâµÄÊÖ¶¯µÄ¼Óɾ£Ï£ò£ã£á£ì£åµÄÁ¬½Ó¡£²»ÓÃÊÖ¶¯ÔÚOracleµÄ¹¤¾ßÀïÈ¥Ò»²½Ò»²½ÅäÖÃÁË¡£

Data Source=ORACLE
¸Ä³ÉORACLE_192.168.1.125
"Data Source=Êý¾Ý¿âÃû;Persist Security Info=True;User ID=Óû§ÃûPassword=ÃÜÂë;Unicode=True"

Oracle ClientÁ¬½ÓµÄÅäÖã¬ÍêÈ«¿ÉÒÔÔÚÉÏÃæµÄÁ½¸öÎļþÀï¡¡¸ã¶¨£¬»òÐíÖ»ÐèÒªÒ»¸öÎļþ£­£­£­tnsnames.ora¡£

¸Ðл¥ÉÏÁ½Î»µÄ»Ø´ð£


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

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

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

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......

OracleÖв鿴×Ô¼º´´½¨µÄ±í - Oracle / ¸ß¼¶¼¼Êõ

Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ­´´½¨µÄ±í£¿
select tname from tab;

SQL code:

--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = 'Óû§Ãû';
--2.ËùÓÐÓû§
select * from tab; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ