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

server2005Á´½Ó·þÎñÆ÷·ÃÎÊoracle,Êý¾Ý²éѯ

EXECUTE SP_ADDLINKEDSERVER 
@SERVER='CDMA',
@SRVPRODUCT='Oracle',
@Provider='MSDAORA',
@DataSrc='CDMA'

--Óû§Ó³Éä
EXEC SP_ADDLINKEDSRVLOGIN 'CDMA','FALSE','sa','cdmauser','cdmaoptr'
--ÔÊÐíRPCµ÷Óã¬ÒÔÖ´Ðд洢¹ý³Ì£» 
exec  sp_serveroption  N'CDMA',  N'rpc',  N'true'

Óï¾äA
SELECT * from CDMA..CDMAUSER.BTSSTATUS_OSS701
ÄÜÕý³£Ô¶ÐÐ


Óï¾äB
SELECT * from CDMA..CDMAUSER.GISDATAUSER.T20091226ÈýÑÇÊÐÌìRP
³ö´í
ÏûÏ¢ 117£¬¼¶±ð 15£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
¶ÔÏó Ãû³Æ 'CDMA..CDMAUSER.GISDATAUSER.T20091226ÈýÑÇÊÐÌìRP¡¯°üº¬µÄǰ׺³¬³öÁË×î´óÏÞÖµ¡£×î¶àÖ»ÄÜÓÐ 3 ¸ö¡£

ÕâÊÇΪʲô£¬¸ÃÔõÑù½â¾ö£¿

ÔÚORACLEÖУ¬SELECT * from GISDATAUSER.T20091226ÊÇÕý³£µÄ

ÔÚORACLEÖУ¬SELECT * from GISDATAUSER.T20091226ÈýÑÇÊÐÌìRP ÊÇÕý³£µÄ


ÔõôûÓиßÊÖÖ¸½Ìѽ£¡£¡£¡

Ó¦¸ÃÕâÑùд£º
SELECT * from (Á´½Ó·þÎñÆ÷Ãû)..(OracleÓû§Ãû).±íÃû;
ÒÔÉϾù´óд¡£

select * from ±íÃû@(Á´½Ó·þÎñÆ÷Ãû)..(OracleÓû§Ãû)
ÕâÑù¿ÉÒÔ£¬ÎÒ¶¼ÊÇÕâÑùÓõÄ

ÒýÓÃ
select * from ±íÃû@(Á´½Ó·þÎñÆ÷Ãû)..(OracleÓû§Ãû)
  ÕâÑù¿ÉÒÔ£¬ÎÒ¶¼ÊÇÕâÑùÓõÄ

×ÖĸҪȫ´óдµÄ¡£


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ