| Adding additional Language in the Oracle Database [message #54123] |
Wed, 30 October 2002 20:54  |
Saha
Messages: 3
Registered: October 2002
|
Junior Member |
|
|
Hi Oracle Gurus,
We have Oracle 8.1.7.0.0 is sitting on AIX-4.0(RS6000) server. Currently we are using English language.
We are planning add two more languages in the database
Korean and japanesh. The database is very small and every day we refreshing the data from AS/400, so the data loss is not a mattet. Can any of you help me to explain the following questions.
1. can be done or not?
4. what are the steps I need to follow up?
3. Do I need to create new database.
4. Which character set is suitable for those language?
5. If this can be done by imp/Exp means what are the parameter I need to apply?
6. Do I need to Increase the Unix file system.
7. Will be any impact on Password and the rest of the thing.
8. How to test after changing whether it is working?
Current NLS Information:
========================
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_COMP BINARY
SQL> SELECT name,value$ FROM sys.props$;
NAME VALUE$
------------------------- -----------------------------------
DICT.BASE 2
DBTIMEZONE 0:00
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_RDBMS_VERSION 8.1.7.2.0
GLOBAL_DB_NAME SDWT
EXPORT_VIEWS_VERSION 8
Please help me on this.
Thanking you in advance
Saha
|
|
|
|
| Re: Adding additional Language in the Oracle Database [message #54346 is a reply to message #54123] |
Tue, 12 November 2002 11:04  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
1. can be done or not?
Yes, could be done.
4. what are the steps I need to follow up?
You have to change the character set of your database. The steps to follow are described Here . However since you have WE8ISO8859P1, it will not be possible to go to UTF8 this way.
3. Do I need to create new database.
No. You can change the CS w/o new database.
4. Which character set is suitable for those language?
UTF8
5. If this can be done by imp/Exp means what are the parameter I need to apply?
Yes. Follow this link Click Here
6. Do I need to Increase the Unix file system.
Yes. UTF8 will recuire three bytes for each character. WE8ISO8859P1 requires two.
7. Will be any impact on Password and the rest of the thing.
No. It's just a CS in the database
8. How to test after changing whether it is working?
Insert some other languages characters and see if you can see them correct.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: Adding additional Language in the Oracle Database [message #54424 is a reply to message #54123] |
Sun, 17 November 2002 17:51 |
Saha
Messages: 3
Registered: October 2002
|
Junior Member |
|
|
Trifon Anguelov, Thank you very much.
Sir, I am confused with the Q&A 3,5.
As you know we can't able to change the CS using
ALTER DATABASE command if the target CS is Super set.
In your reply you have mentioned that we no need to create new database. Then which option will change the character set if we do Imp/Exp??
Thanks in advance.
Saha
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
