update props$ set value$ [message #547908] |
Sun, 18 March 2012 20:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/62f312ed68aa2b69e3a7ad9421a76080?s=64&d=mm&r=g) |
kevinlky
Messages: 5 Registered: October 2011 Location: Singapore
|
Junior Member |
|
|
Since the past, our developer uses this command
"update props$ set value$ set = 'ZHS16GBK' where name='NLS_CHARACTERSET' ;" and
update props$ set value$='WE8MSWIN1252' where name='NLS_CHARACTERSET';
to update the sys table which is not supported by oracle.
However, I decided to use CSSCAN to scan through the database and see if the new characterset will work.
But before using CSSCAN, I will like to know which characterset to set back as our developer does not know which is the original characterset.
|
|
|
|
|
|
|
|
|
|
|