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
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡± ÎÒÓõÄÊÇoracle 8£¬ÏÈÇ°ÓõÄ10gÒ²Óöµ½ÀàËƵÄÎÊÌâ ʹÓÃmicrosoft ole db pro ......