oracle常用sql

--创建表空间自动扩展,名字是MY_TS,文件是D:\apply\oracle11gxe\app\oracle\oradata\XE\MY_TS.DBF
CREATE TABLESPACE MY_TS LOGGING DATAFILE 'D:\apply\oracle11gxe\app\oracle\oradata\XE\MY_TS.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
CREATE TEMPORARY TABLESPACE MY_TEMP_TS TEMPFILE 'D:\apply\oracle11gxe\app\oracle\oradata\XE\MY_TEMP_TS.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 512M EXTENT MANAGEMENT LOCAL;
--创建用户MYUSER/MYUSER
CREATE USER MYUSER IDENTIFIED BY MYUSER DEFAULT TABLESPACE MY_TS TEMPORARY TABLESPACE MY_TEMP_TS;

grant connect to MYUSER;
grant resource to MYUSER;
grant dba to MYUSER;
-- Grant/Revoke system privileges
grant create session to MYUSER;
grant alter session to MYUSER;
grant unlimited tablespace to MYUSER;

-------------------------------------------------------------------------

修改 oracle xe 默认中文字符集成为：SIMPLIFIED CHINESE_CHINA.ZHS16GBK 

博客分类： Oracle 

修改 oracle xe 默认中文字符集成为：SIMPLIFIED CHINESE_CHINA.ZHS16GBK  

Oracle XE 执行安装程序后，很简单的默认为  SIMPLIFIED CHINESE_CHINA.AL32UTF8 ，通过如下方法可以修改成为 ZHS16GBK 。 

---------------------- 

sqlplus /nolog

connect / as sysdba

shutdown  immediate

startup  mount

alter  system  enable  restricted  session  ;

alter  system  set  JOB_QUEUE_PROCESSES=0;

alter  system  set  AQ_TM_PROCESSES=0;

alter  database  open  ;

alter  database  character  set  internal_use  ZHS16GBK  ;  

shutdown  immediate

startup