Alterar character set Oracle XE

SQL> ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP RESTRICT;
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

SQL> ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH;

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP RESTRICT;

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP;

Leave a Reply Cancelar resposta