修改oracle数据库字符集的方法

> shutdown immediate;

Database clo.

Database dismounted.

ORACLE instance shut down.SQL> STARTUP

ORACLE instance started.


Total System Global Area 235999352 bytes

Fixed Size 450680 bytes

Variable Size 201326592 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.SQL> select name,value$ from props$ where name like '%NLS%';


NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_LANGUAGE

AMERICAN


NLS_TERRITORY

AMERICA


NLS_CURRENCY

$



NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_ISO_CURRENCY

AMERICA


NLS_NUMERIC_CHARACTERS

.,

NLS_CHARACTERSET

ZHS16GBK



NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_CALENDAR

GREGORIAN


NLS_DATE_FORMAT

DD-MON-RR


NLS_DATE_LANGUAGE

AMERICAN



NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_SORT

BINARY


NLS_TIME_FORMAT

HH.MI.SSXFF AM


NLS_TIMESTAMP_FORMAT

DD-MON-RR HH.MI.SSXFF AM



NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_TIME_TZ_FORMAT

HH.MI.SSXFF AM TZR


NLS_TIMESTAMP_TZ_FORMAT

DD-MON-RR HH.MI.SSXFF AM TZR


NLS_DUAL_CURRENCY

$



NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_COMP

BINARY


NLS_LENGTH_SEMANTICS

BYTE


NLS_NCHAR_CONV_EXCP

FALSE



NAME

------------------------------

VALUE$

------------------------------------------------------------------------------------------------------------------------

NLS_NCHAR_CHARACTERSET

AL16UTF16


NLS_RDBMS_VERSION

9.2.0.1.0



20 rows selected.