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

oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄÎÊÌâ

  CREATE DATABASE LINK tzhouse CONNECT TO (houseÊý¾Ý¿âÃû) IDENTIFIED BY (lf.comÃÜÂë) USING (strÁ¬½Ó×Ö·û´®);
±¨ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø
Ö¸ÏòµÄÊÇlf.com
ÔõôÐ޸ģ¿£¿


create database link SID_NAME connect to USER identified by USERPWD using 'SID2';

create database link target_database
connect to user identified by password
using ...

Óï·¨ÎÒµÄû´í°¡£¬Ò²ÊÇÒ»Ñù°¡¡£¡£¡£
ÒòΪÎÒµÄÃÜÂë¸ñʽÊǺ¬.·ûºÏµÄ¡£¡£
²»ÖªµÀÕâÀïÓÐûÓÐʲôӰÏ죬Ӧ¸ÃÔõôд

ÒýÓÃ
create database link target_database
connect to user identified by password
using ...


½âÊÍÏ£¬¸Õ²ÅдµÄtarget_databaseÓ¦¸ÃÊÇÄã×Ô¼º¸øÕâ¸öÁ´½ÓÆðµÄÃû×Ö¡£

ÃÜÂë¿ÉÒÔ´ø·ûºÅ.Â𣿣¿

ÒѾ­½â¾ö£¬Ð»Ð»¸÷λ£¡
ÔÚÃÜÂë´¦¼Ó¸öË«ÒýºÅ¼´¿É£¡£¡



Ïà¹ØÎÊ´ð£º

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

ÊÇ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Êý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

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