characterset 변환

2012. 7. 17. 09:10Oracle/Oracle Study

반응형

SQL> !lsnrctl stop listener

...

..

.


SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.


Total System Global Area 2550136832 bytes

Fixed Size                  2022920 bytes

Variable Size             536871416 bytes

Database Buffers         1996488704 bytes

Redo Buffers               14753792 bytes

Database mounted.

SQL> alter system enable restricted session;


System altered.


SQL> alter system set job_queue_processes=0;


System altered.


SQL> alter system set aq_tm_processes=0;


System altered.


SQL> alter database open;


Database altered.


SQL> alter database character set internal_use KO16KSC5601;


Database altered.


SQL> shutdown immediate;


SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.


Total System Global Area 2550136832 bytes

Fixed Size                  2022920 bytes

Variable Size             536871416 bytes

Database Buffers         1996488704 bytes

Redo Buffers               14753792 bytes

Database mounted.

Database opened.

SQL> select * from props$ where name = 'NLS_CHARACTERSET';


NAME

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

VALUE$

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

COMMENT$

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

NLS_CHARACTERSET

KO16KSC5601

Character set


SQL> !lsnrctl start listener

...

..

.

반응형

'Oracle > Oracle Study' 카테고리의 다른 글

기본적인 궁금증들(?)  (0) 2012.09.23
Windows Oracle 10g 설치  (0) 2012.09.23
minus 에 대한 위험(?)  (0) 2012.06.21
Datafile resize에 대한 오해(?)  (0) 2012.01.20
sh 계정 생성  (0) 2011.12.26