캐릭터셋 변경

CHARACTER SET Conversion

(1) 확인
SVRMGR> select name c1, value$ c1 from sys.props$;

(2) 변경전 작업 -- rbs maxextents, rbs tablespace add,
system tablespace add
SVRMGR> alter rollback segment <rbs3> storage (maxextents 505)
SVRMGR> alter tablespace rbs add
datafile '</~/oradata/VIS/rbs02.dbf>' size 500m;

(3) 변경
SVRMGR> startup
SVRMGR> connect intenral
SVRMGR> update sys.props$ set value$='KO16KSC5601' where name='NLS_CHARACTERSET';
SVRMGR> update sys.props$ set value$='KO16KSC5601' where name='NLS_NCHAR_CHARACTERSET';
SVRMGR> commit;
SVRMGR> shutdown

* init<SID>.ora에서 job_queue_processes, aq_tm_processes,snapshot_refresh_processes항목이 있으면 막아준다...

SVRMGR> startup mount exclusive
SVRMGR> alter system enable restricted session;
SVRMGR> alter database open;
SVRMGR> alter database character set internal_use KO16KSC5601;
SVRMGR> alter database national character set internal_use KO16KSC5601;
SVRMGR> shutdown

* 오라클 환경화일에서 character set을 변경한다.
SVRMGR> startup
SVRMGR> exit