¸ß·ÖÇó½â£¡£¡£¡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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
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µÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......