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

¸ß·ÖÇó½â£¡£¡£¡OracleÓëSQL ServerÊý¾Ýͬ²½

Ò»¸öÊÇOracle£¨9i£©Êý¾Ý¿â£¬ÁíÒ»¸öÊÇSQL Server£¨2000£©Êý¾Ý¿â£¬
Á½¸öÊý¾Ý¿âµÄ±í½á¹¹²»Ïàͬ£¬ÐèҪͬ²½ÆäÖеIJ¿·ÖÊý¾Ý£¬²¢ÇÒÊǽ«OracleµÄ²¿·ÖÊý¾Ýͬ²½µ½SQL ServerÊý¾Ý¿âÖС£

ÉèÏëÁËÒÔϼ¸ÖÖ·½·¨£º
1.½øÐÐÊý¾Ý¿â¿ìÕÕ£¬ÊµÏÖͬ²½£»
2.дӦÓóÌʽ¶ÁÈ¡OracleÈÕÖ¾£¬È»ºó½âÎöÈÕÖ¾£¬ÔÙÖØÐÂ×é×°SQLÓï¾ä£¬²Ù×÷SQL ServerÊý¾Ý¿â£»
3.±È¶ÔÐèҪͬ²½µÄÊý¾Ý£¬ÔÙ½øÐиüеȲÙ×÷¡£

µ«ÊÇÓöµ½ÒÔÏÂÎÊÌ⣺
·½·¨1.Ö»ÊÔ¹ý´ÓSQL Serverͬ²½µ½Oracle£¬Ã»×ö¹ý´ÓOracleͬ²½µ½SQL Server¡££¿£¿
·½·¨2.²»ÖªµÀÔõÑùÓÃJava½âÎöOracleÈÕÖ¾£¿£¿
·½·¨3.ºÃÏñ²»Ì«ÏÖʵ¡£

¸÷λÓÐʲôºÃµÄ°ì·¨À´ÊµÏÖÂð£¿

Ç뾡Á¿Ð´µÃÏêϸЩ£¬»òÕßÄÜÒýÓÃÆäËü¿ÉÓõÄÌù×Ó¡£Ð»Ð»£¡¡«¡«

ÎÒÐèҪʵÏÖ°´Ììͬ²½¡£

Äܾ¡Á¿ÏêϸµãÂð£¿Ð»Ð»¡«

½¨ÒéÄã¿´SQL SERVERĿ¼Ï°ïÖúÎĵµÀïÃæµÄ½Ì³Ì²¿·Ö£¬ÓÐSSISµÄÏêϸ½éÉÜÓëʹÓÃÖ¸ÄÏ£¬Äã°´½Ì³Ì×öÒ»±éÖ®ºó£¬¼´¿ÉÃ÷°×SSISµÄ²Ù×÷ºÍ´¦Àí¡£
µ±Äã×öºÃÒ»¸ö¹¤³ÌÖ®ºó£¬Ö»ÐèÒªÔÚSQL SERVERÖÐн¨Ò»¸ö´úÀí×÷Òµ£¬È»ºóÖ¸ÏòÄã×öºÃµÄSSIS°ü£¬ÔÙÅäÖõ÷¶È¼Æ»®£¨ÈçÿÌì3µãÖ´ÐУ©¾Í¿ÉÒÔÁË¡£

ÒýÓÃ
½¨ÒéÄã¿´SQL SERVERĿ¼Ï°ïÖúÎĵµÀïÃæµÄ½Ì³Ì²¿·Ö£¬ÓÐSSISµÄÏêϸ½éÉÜÓëʹÓÃÖ¸ÄÏ£¬Äã°´½Ì³Ì×öÒ»±éÖ®ºó£¬¼´¿ÉÃ÷°×SSISµÄ²Ù×÷ºÍ´¦Àí¡£
µ±Äã×öºÃÒ»¸ö¹¤³ÌÖ®ºó£¬Ö»ÐèÒªÔÚSQL SERVERÖÐн¨Ò»¸ö´úÀí×÷Òµ£¬È»ºóÖ¸ÏòÄã×öºÃµÄSSIS°ü£¬ÔÙÅäÖõ÷¶È¼Æ»®£¨ÈçÿÌì3µãÖ´ÐУ©¾Í¿ÉÒÔÁË¡£

ÇëÎÊÊÇҪʹÓÃDTSÊý¾Ýת»»·þÎñÂð?SSISûÓÐÓùý,ÓÐ×ÊÁÏÂð?


DTS

²é¿´DTSµÄ×ÊÁÏ£¬ºÃÏñÖ»ÄÜͬ²½Ïàͬ±í½á¹¹µÄÊý¾Ý¡£
ÎÒÐèÒª´ÓÊý¾Ý¿âA£¨Oracle 9i£©ÖÐÈ¡³öÁ½ÕűíµÄ²¿·Ö×Ö¶ÎÊý¾Ýͬ²½µ½Êý¾Ý¿âB


Ïà¹ØÎÊ´ð£º

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

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

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

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

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 - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ