oracle xe thai 8 bit

sqlplus / as sysdba

CREATE USER xxx IDENTIFIED BY pppp DEFAULT TABLESPACE users;
GRANT CONNECT, RESOURCE TO xxx;
GRANT privilege TO xxx;

GRANT DBA TO xxx;


SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE TH8TISASCII;
SHUTDOWN;
STARTUP;

ทำ reverse
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
SHUTDOWN;
STARTUP;


http://www.narisa.com/forums/index.php?showtopic=13641

No comments: