Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Precautions i need to take when changing the Character set

WilhelmAug 5 2007 — edited Aug 5 2007

Hi,
ORACLE VERSION: 10G Release 1 (10.1.0.3.0)

I am going to change my database's characterset from AL32UTF8 to WE8MSWIN1252 character set and AL16UTF16 NCHAR character set. So i have few questions for you.

1. What is the difference between Character Set and National Character set? Do i have to set both?

2. What are precautions that i need to take while changing the characterset?

3. What are JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES parameters in Plain English? Why do i have to set these parameters to 0 as mentioned in this post below.
454102

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2007

Added on Aug 5 2007

#general-database-discussions

1 comment

361 views