1銆佹鏌ユ湇鍔″櫒涓奜racle鏁版嵁搴撶殑瀛楃闆?nbsp;
sqlplus /nolog
SQL> connect / as sysdba
榪炴帴鎴愬姛.
SQL> desc props$
鍒楀悕 鍙┖鍊煎惁 綾誨瀷
------------------------------- -------- ----
NAME NOT NULL VARCHAR2(30)
VALUE$ VARCHAR2(2000)
COMMENT$ VARCHAR2(2000)
SQL> col value$ format a40
SQL> select name,value$ from props$;
NAME VALUE$
------------------------------ -------------------------
DICT.BASE 2
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_CALENDAR GREGORIAN
NLS_RDBMS_VERSION 7.3.4.0.0
GLOBAL_DB_NAME ORACLE.WORLD
EXPORT_VIEWS_VERSION 3
NLS_CHARACTERSET鍜孨LS_CHAR_CTERSET榪欎釜鍙傛暟搴旇鏄痁HS16GBK錛屽涓嶆槸錛屾敼涓哄畠銆?nbsp;
SQL*Plus涓慨鏀規柟娉曪細
SQL> update props$ set value$='ZHS16GBK' where name='NLS_CHARACTERSET';
2銆佺‘璁ゅ瓧絎﹂泦鏄惁淇敼鐨勪笉褰誨簳銆?br />
SELECT DISTINCT (NLS_CHARSET_NAME(CHARSETID)) CHARACTERSET,
DECODE(TYPE#, 1,
DECODE(CHARSETFORM, 1, 'VARCHAR2', 2, 'NVARCHAR2', 'UNKOWN'),
9,
DECODE(CHARSETFORM, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKOWN'),
96,
DECODE(CHARSETFORM, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'),
112,
DECODE(CHARSETFORM, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN
FROM SYS.COL$
WHERE CHARSETFORM IN (1, 2)
AND TYPE# IN (1, 9, 96, 112);
3銆佸鏋滀笂闈㈢殑鏌ヨ鐨勭‘鏄劇ず鏈夊涓瓧絎﹂泦鐨勮瀹氾紝鍒欒繘琛屽涓嬪鐞嗭細
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
COL VALUE NEW_VALUE CHARSET
SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
COL VALUE NEW_VALUE NCHARSET
SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_NCHAR_CHARACTERSET';
--INTERNAL_USE鏄病鏈夊啓鍦ㄦ枃妗d腑鐨勫弬鏁幫紝鐢ㄤ互寮哄埗瀹屾垚瀛楃闆嗕竴鑷村寲
ALTER DATABASE CHARACTER SET INTERNAL_USE &CHARSET;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE &NCHARSET;
SHUTDOWN IMMEDIATE;
STARTUP;
-- 鍐嶆鍚姩鏁版嵁搴撲竴閬?br />
SHUTDOWN IMMEDIATE;
STARTUP;
**************娉ㄦ剰****************
鏈漢鍦ㄤ嬌鐢ㄤ笂闈㈢殑鏂規硶璁劇疆浠ュ悗Oracle10g鍙互姝e父浣跨敤錛屽湪瀵煎叆dmp錛宻ql鏂囦歡鐨勬椂鍊欏垯闇瑕佸湪Linux涓仛濡備笅璁劇疆
sql鏂囦歡錛宒mp鏂囦歡鍦ㄥ鍏racle鐨勬椂鍊欓渶瑕佽緗瓧絎﹂泦
export LANG=zh_CN.GBK //榪欎釜鏄痩inux鐨勫瓧絎﹂泦璁劇疆
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK //榪欎釜鏄痮racle鐨勫瓧絎﹂泦璁劇疆
3sNews鏈鏂版秷鎭紝寰蔣鐜板湪涔熷凡緇忔垚涓?a onclick="javascript:tagshow(event, 'OGC');" href="javascript:;" target="_self">OGC涓昏鎴愬憳涔嬩竴,OGC緇勭粐涔熷寰蔣鐨勫姞鍏ユ劅鍒伴珮鍏?浠栦滑鏈闇瑕佸仛鐨勪簨鎯呭綋鐒舵槸鎶奦irtual Earth 鍜?SQL Server 2008綰沖叆OpenGIS鍏煎鏍囧噯.寰蔣鏄殢Google涔嬪悗鍔犲叆OGC鍗忎細鐨勩傝?澶у法澶寸殑鍔犲叆涔熸爣蹇楃潃絀洪棿淇℃伅浜т笟宸茶繘鍏ュ彂灞曠殑蹇濺閬擄紝閫愭笎鎴愪負IT涓繪祦銆?span style="font-weight: bold">
Google Earth鐨凨ML鏂囦歡鏍煎紡鏄紑鏀懼湴鐞嗗崗浼氱殑鏈浣沖簲鐢ㄤ箣涓,榪欎竴鍗忎細鍖呭惈345涓垚鍛?娑電洊鍏徃銆佹斂搴滄満鏋勫拰澶у絳夎鑹?浠栦滑鐨勭洰鏍囨槸寤虹珛涓涓狾penGIS鏍囧噯.2007騫存槬瀛?Google閫掍氦浜咾eyhole Markup Language (KML 2.1)--Google Earth鐨勬渶鏂版牸寮?閫氳繃浜哋GC鐨勯獙璇?寰堝揩,瀹冨湪涓栫晫鑼冨洿鍐呭紩璧蜂簡騫挎硾鐨勫叴瓚?OGC涔熷皢浠栦滑鍔犲叆浜?-- 鍦扮悊鏍囩ず璇█(GML)涓?
鍘熻創錛?a >http://www.3snews.net/index.php/action_viewnews_itemid_16707.html
鍙互鍒癘GC涓嬭澆GML鑻辨枃鐗?www.opengeospatial.org
涓嬭澆鍦板潃:http://www.fruitres.cn/servlet/buyproductservlet?tag=single&tag1=info&PRODUCT_ID=1460914139&number=0
鏇村涓嬭澆:http://www.fruitres.cn/