--update props$ set value$='TH8TISASCII' where name='NLS_CHARACTERSET'; update props$ set value$='WE8MSWIN1252' where name='NLS_CHARACTERSET'; commit; shutdown immediate startup SELECT * FROM NLS_DATABASE_PARAMETERS where PARAMETER like '%NLS_CHAR%'; quit