Page History

...

http://www.getyourcontent.com/1/6565-0/Oracle-Database-XE----SQL.aspx

Character set módosítása

http://dbaportal.eu/?q=node/15^{Image Added}

cmd> sqlplus /nolog
sql> connect / as sysdba
sql> SHUTDOWN IMMEDIATE;
sql> STARTUP MOUNT;
sql> ALTER SYSTEM ENABLE RESTRICTED SESSION;
sql> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
sql> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
sql> ALTER DATABASE OPEN;
sql> ALTER DATABASE CHARACTER SET INTERNAL_USE EE8MSWIN1250;
sql> SHUTDOWN;
sql> STARTUP RESTRICT;
sql> SHUTDOWN;
sql> STARTUP;