oracle10g修改数据库字符集

《oracle10g修改数据库字符集》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、oracle10g修改数据库字符集2008-01-1615:561:一、常规方法修改数据库字符集2:3:当前数据库字符集:4:SQL>selectname,value$fromprops$wherenamelike'%NLS%';5:6:NAMEVALUE$7:------------------------------------------------------------8:NLS_LANGUAGEAMERICAN9:NLS_TERRITORYAMERICA10:NLS_CURRENCY$11:NLS_ISO_CURRENCYAMERICA12:NLS_NUMERIC_CHARACTE

2、RS.,13:NLS_CHARACTERSETUS7ASCII14:......15:16:20rowsselected.17:18:SQL>connzwfha/admin19:Connected.20:SQL>select*fromtab;21:22:TNAMETABTYPECLUSTERID23:-----------------------------------------------24:HRMS_EMPINFO_COMPANYTABLE25:HRMS_EMPINFO_DEPARTMENTTABLE26:HRMS_EMPINFO_DIRECTORTABLE27:HRMS_EMPINF

3、O_EDUCATIONTABLE28:HRMS_EMPINFO_EMPLOYEETABLE29:HRMS_EMPINFO_EXPERIENCETABLE30:HRMS_EMPINFO_FAMILYTABLE31:HRMS_EMPINFO_HONORTABLE32:HRMS_EMPINFO_JOBTABLE33:HRMS_EMPINFO_STATUSTABLE34:HRMS_EMPINFO_TEAMTABLE35:36:11rowsselected.37:38:SQL>selectnamefromHRMS_EMPINFO_EMPLOYEEwhererownum<3;39:40:NAME41:--

4、--------------------------------------42:关鹏燕43:周杨英44:45:46:中文显示是正常的。47:关闭数据库，打开到mount状态，准备修改数据库字符集(修改前最好备份一下)48:49:SQL>shutdownimmediate50:Databaseclosed.51:Databasedismounted.52:ORACLEinstanceshutdown.53:SQL>54:SQL>startupmount55:ORACLEinstancestarted.56:57:TotalSystemGlobalArea117440512bytes58:Fix

5、edSize787728bytes59:VariableSize91224816bytes60:DatabaseBuffers25165824bytes61:RedoBuffers262144bytes62:Databasemounted.63:SQL>64:SQL>altersystemenablerestrictedsession;65:66:Systemaltered.67:68:SQL>showparameterprocesses69:70:NAMETYPEVALUE71:---------------------------------------------------------

6、----------72:aq_tm_processesinteger073:db_writer_processesinteger174:gcs_server_processesinteger075:job_queue_processesinteger1076:log_archive_max_processesinteger277:processesinteger15078:SQL>79:SQL>altersystemsetjob_queue_processes=0;80:81:Systemaltered.82:83:SQL>altersystemsetaq_tm_processes=0;84

7、:85:Systemaltered.86:87:SQL>alterdatabaseopen;88:89:Databasealtered.90:91:SQL>alterdatabasecharactersetzhs16gbk;92:alterdatabasecharactersetzhs16gbk93:*94:ERRORatline1:95:ORA-12716:CannotALTERDATABASE