개발은 너무해

characterset 변환 본문

Oracle/Oracle Study

characterset 변환

까칠 평생초보 2012.07.17 09:10

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
characterset 변환  (0) 2012.07.17
minus 에 대한 위험(?)  (0) 2012.06.21
Datafile resize에 대한 오해(?)  (0) 2012.01.20
sh 계정 생성  (0) 2011.12.26
0 Comments
댓글쓰기 폼