Home » RDBMS Server » Server Administration » update props$ set value$ (oracle 10g Enterprise, 10.2.0.1.0, Windows XP)
update props$ set value$ [message #547908] |
Sun, 18 March 2012 20:25  |
 |
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.
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Thu May 15 02:34:43 CDT 2025
|