Oracle²åÈëÖÐÎijöÏÖÂÒÂë - Oracle / ¿ª·¢
Oracle²åÈëÖÐÎijöÏÖÂÒÂë »·¾³£ºsolaris 10 Êý¾Ý¿â£ºoracle 10g ¿Í»§¶Ë£ºPL/SQL Developer(Windows) ÔÚsolarisÖÐÓÃsqlplus update»òinsertʱÓÃÖÐÎÄ£¬PL/SQL Developer(windows)³öÏÖÂÒÂ룬 ÔÚPL/SQL Developer(windows)ÖÐinsert»òupdateʱ²»»áÂÒÂë¡£
×Ö·û¼¯ÎÊÌâ¡£ ÉèÖÃwindows×Ö·û¼¯ºÍÊý¾Ý¿â×Ö·û¼¯Ò»Ö¡£ ÄãµÄ solarisµÄ²Ù×÷ϵͳ×Ö·û¼¯ÉèÖò»¶Ô ¿ÉÒÔÉèÖÃ×Ö·û¼¯È磺export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK ÉèÖóÉÓëÊý¾Ý¿â¶ÔÓ¦µÄ×Ö·û¼¯ ²åÈëµÄÊý¾ÝÓëÊý¾Ý¿âµÄ×Ö·û¼¯²»Æ¥Åä ³ö´í£¬ÕÒ²»µ½`CHINESE_CHINA.ZHS16GBK'°¡ [root@UNIXServer:/]#export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK -bash: export: `CHINESE_CHINA.ZHS16GBK': not a valid identifierÒýÓà ³ö´í£¬ÕÒ²»µ½`CHINESE_CHINA.ZHS16GBK'°¡ [root@UNIXServer:/]#export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK -bash: export: `CHINESE_CHINA.ZHS16GBK': not a valid identifier ÒªÓÃË«ÒýºÅ: export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" »¹ÊÇÂÒÂë°¡ ÔÚsolarisÊäÈëÈçϺó£¬sqlplus²åÈëÖÐÎÄ£¬PL/SQL Developer(windows)»¹ÊÇÂÒÂë°¡ export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" °²×°Êý¾Ý¿âʵÀýµÄʱºò£¬ Ñ¡ÔñÕâ¸ö×Ö·û¼¯£º SIMPLIFIED CHINESE_CHINA.ZHS16GBK ÄãÒª¿´Ò»ÏÂÄãµÄÊý¾Ý¿âÀïÊÇʲô×Ö·û¼¯£¿ select * from nls_database_parameters t where t.PARAMETER='NLS_CHARACTERSET'; SQL> select * from nls_database_para
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬ µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......