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

sqlserverºÍoracleÈçºÎ×öÊý¾Ý¿âͬ²½

ÒªÇó£º
1£©½«Ò»Ì¨oracleÖ÷Êý¾Ý¿âµÄÊý¾ÝÖеÄijЩ±íͬ²½¸üе½¶ą̀sqlserver·þÎñÆ÷É϶ÔÓ¦±íÖУ»
2£©×îºÃÄÜʱʵͬ²½£¬Èç¹û²»ÄÜʱʵ£¬¶¨Ê±Í¬²½Ò²¿ÉÒÔ¡£
3£©×îºÃ²»ÒÀÀµ³ÌÐò×öͬ²½¸üУ¬µ¥´¿Í¨¹ýÊý¾Ý¿â×ÔÉíʵÏÖ¡£

Ìõ¼þ£º
oracle9i;sqlserver2000;

Ã²ËÆ²»´ó¿ÉÄÜ

¾Í±»ÅÐËÀÐÌÁË£¿£¿


×ö¸öJOB

ÒýÓÃ
ÒýÓÃÂ¥Ö÷ stonec µÄ»Ø¸´:
ÒªÇó£º
1£©½«Ò»Ì¨oracleÖ÷Êý¾Ý¿âµÄÊý¾ÝÖеÄijЩ±íͬ²½¸üе½¶ą̀sqlserver·þÎñÆ÷É϶ÔÓ¦±íÖУ»
2£©×îºÃÄÜʱʵͬ²½£¬Èç¹û²»ÄÜʱʵ£¬¶¨Ê±Í¬²½Ò²¿ÉÒÔ¡£
3£©×îºÃ²»ÒÀÀµ³ÌÐò×öͬ²½¸üУ¬µ¥´¿Í¨¹ýÊý¾Ý¿â×ÔÉíʵÏÖ¡£

Ìõ¼þ£º
oracle9i;sqlserver2000;


Èç¹û·ÇÒªÕâÁ½¸ö¿âͬ²½,
1.ʹÓóÌÐòÀûÓÃtimer¶¨Ê±Æ÷´ÓÒ»¸ö¿â»ñÈ¡Êý¾Ý¸üе½ÁíÍâÒ»¸ö¿â.
2.ʹÓô¥·¢Æ÷,Ò»µ©Êý¾Ý·¢Éú¸üÐÂ,²åÈëµÈ¾ÍÁ¢¼´¸üе½ÁíÍâÒ»¸ö¿â.
SQL codeÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ëselect*fromopendatasource('MSDAORA','Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDBFOR OracleµÄÇý¶¯£¬

×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍÓû§ÃûÖ®¼äÊÇÁ½¸öµã£»
ÀýÈç:selecttop10*fromopendatasource('MSDAORA','Data Source=HZTEST;User ID=osstest;Password=a1234')..OSSTEST.SUBSCRIBER

±¾µØOracle¿Í»§¶ËÅäÖÃÎļþÖÐÄÚÈÝÈçÏÂ:
HZTEST=
  (DESCRIPTION=
    (ADD


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

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

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

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

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ