Solved

Oracle character set

Posted on 2011-03-21
19
883 Views
Last Modified: 2013-11-11
How do we change oracle database character set on oracle 11g database on Linux server. I really appreciate your help
0
Comment
Question by:hussainkhan22
  • 6
  • 6
  • 5
  • +2
19 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
are you sure you need to change character sets?

you may need to create a new  database with the correct set  
0
 

Author Comment

by:hussainkhan22
Comment Utility
If I just want to change the character set without creating a new database, is it possible
0
 

Author Comment

by:hussainkhan22
Comment Utility
Do we have any utility to change the character set?
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
Comment Utility
>>>  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
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
>> 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
 
LVL 5

Expert Comment

by:morgulo
Comment Utility
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
morgulo's link is merely an older version (11gR1) of the same doc link posted earlier
0
 

Author Comment

by:hussainkhan22
Comment Utility
How do we check what is the current character set we having in our database?
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
 

Author Comment

by:hussainkhan22
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
I believe csscan is a command line utility not a sqlplus command.
0
 

Author Comment

by:hussainkhan22
Comment Utility
What is the log file location for csscan?
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
0
 

Author Comment

by:hussainkhan22
Comment Utility
What is the super set of US7ASCII so that I can change my character set which is US7ASCII currently
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
What is the base requirement for this question?

Specifically, what data can't you collect in you current chracterset?
0
 
LVL 20

Expert Comment

by:Amitkumar Panchal
Comment Utility
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now