Oracle XE NLS_CHARACTERSET

CONNECT SYS/пароль AS SYSDBA;

UPDATE SYS.PROPS$SET VALUE$ = 'CL8MSWIN1251'WHERE NAME = 'NLS_CHARACTERSET';

COMMIT;


SHUTDOWN IMMEDIATE;


STARTUP MOUNT;


ALTER SYSTEM ENABLE RESTRICTED SESSION;


ALTER DATABASE OPEN;


ALTER DATABASE XE CHARACTER SET CL8MSWIN1251;

ALTER DATABASE XE NATIONAL CHARACTER SET CL8MSWIN1251;

SHUTDOWN IMMEDIATE;

STARTUP;