This forum is currently locked. You can't register or post questions at this time. (read more)

character set migration

All posts relating to Oracle database administration.

Moderator: Tim...

kytemaniac
Senior Member
Posts: 234
Joined: Tue May 19, 2009 12:59 am

character set migration

Postby kytemaniac » Tue Apr 09, 2013 7:12 am

Hi

rdbms version from alert log

Code: Select all

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

inside the alert log

Code: Select all

alter database character set INTERNAL_CONVERT WE8MSWIN1252
Tue Apr 09 01:23:42 2013
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: E:\EXCEL_DATA\EXCEL\REDO02.LOG
Thread 1 advanced to log sequence 3 (LGWR switch)
  Current log# 3 seq# 3 mem# 0: E:\EXCEL_DATA\EXCEL\REDO03.LOG
Tue Apr 09 01:23:50 2013
Updating character set in controlfile to WE8MSWIN1252



I've found this alter database syntax from http://docs.oracle.com/cd/B10500_01/ser ... tm#2129860

notice found in 9.2 manual but not in 11gr2 manual? will there be any implications? 11gr2 sql alter database syntax does not have default settings clause.

from http://docs.oracle.com/cd/B10500_01/ser ... tm#1009904 I

Migrating Character Data Using the ALTER DATABASE CHARACTER SET Statement



I guess the DBA or the script is trying to migrate the character set right?

from http://docs.oracle.com/cd/B10500_01/ser ... tm#2129860

The following statements change the database character set and national character set to the UTF8 character set:

ALTER DATABASE CHARACTER SET UTF8;
ALTER DATABASE NATIONAL CHARACTER SET UTF8;


from http://docs.oracle.com/cd/B10500_01/ser ... tm#1009904

Because the ALTER DATABASE CHARACTER SET statement does not convert data



two statements seems to be a little bit contradictory. What happen if new data is inserted?

thanks for any assistance rendered!

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: character set migration

Postby Tim... » Tue Apr 09, 2013 7:39 am

Hi.

The supported way to do character set conversions is to use CSSCAN and CSALTER.

http://www.oracle-base.com/articles/10g ... ration.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron