• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 942
  • Last Modified:

Oracle character set

How do we change oracle database character set on oracle 11g database on Linux server. I really appreciate your help
0
hussainkhan22
Asked:
hussainkhan22
  • 6
  • 6
  • 5
  • +2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Have you checked the docs?  There are rules on what you can and cannot do when changing charactersets.

Depending on the current one and the 'new' one, you might not be able to.
0
 
sdstuberCommented:
are you sure you need to change character sets?

you may need to create a new  database with the correct set  
0
 
hussainkhan22Author Commented:
If I just want to change the character set without creating a new database, is it possible
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
hussainkhan22Author Commented:
Do we have any utility to change the character set?
0
 
sdstuberCommented:
>>>  is it possible

not directly, you "might" be able to do export/import after creating a new database

look in chapter 11 of the Globalization Support Guide and determine if you will be able to do it after checking the character sets you want to migrate from and to

http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/ch11charsetmig.htm#g1011430
0
 
sdstuberCommented:
>> Do we have any utility to change the character set?

As seen in the doc link above, yes,  CSALTER,  but there are limits on that too.

0
 
sdstuberCommented:
morgulo's link is merely an older version (11gR1) of the same doc link posted earlier
0
 
hussainkhan22Author Commented:
How do we check what is the current character set we having in our database?
0
 
slightwv (䄆 Netminder) Commented:
The NLS_DATABASE_PARAMETERS view.

Sdstuber asked, I'll ask again:  If you don't know the current characterset, how do you need to know you change it?
0
 
hussainkhan22Author Commented:
When I am running
SQL> CSSCAN /AS SYSDBA FULL=Y

Getting the below error:
SP2-0734: unknown command begining "csscan / a..." - rest of the line ignored.
0
 
slightwv (䄆 Netminder) Commented:
I believe csscan is a command line utility not a sqlplus command.
0
 
hussainkhan22Author Commented:
What is the log file location for csscan?
0
 
hussainkhan22Author Commented:
What is the super set of US7ASCII so that I can change my character set which is US7ASCII currently
0
 
sdstuberCommented:
I don't know of a complete list printed anywhere.

from the chapter 11 link above "many sets" could be

when you run your scan specify a TOCHAR set to test with and you'll get results to tell you if you can do it or not.


We can't tell you X and Y will work  we don't know your X and Y you want to try.  Even if we did, we couldn't tell you without running the scan ourselves, which we can't do because we don't have your data
0
 
slightwv (䄆 Netminder) Commented:
What is the base requirement for this question?

Specifically, what data can't you collect in you current chracterset?
0
 
Amitkumar PSr. ConsultantCommented:
You need to create a new database specifying a new character set. Export/Import will work but there are chances to have the currupted data in imported DB.
0
 
slightwv (䄆 Netminder) Commented:
>>You need to create a new database specifying a new character set.

Not necessarily true.  It depends on the FROM and TO charactersets.  If one is a subset of the other, you can do it in place.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 6
  • 6
  • 5
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now