You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Telepítés Debian-ra

http://matyigabor.hu/konfiguracio/oracle-xe-telepitese-debianra

Tablespace létrehozása

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

Character set módosítása

http://dbaportal.eu/?q=node/15

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;

  • No labels