oracle备忘

创建数据库：

CREATE TABLESPACE TEST datafile 
'test.dbf' size 100M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED default storage (initial 128K next 2M  pctincrease 0);

创建用户：

CREATE USER "RAV2" IDENTIFIED BY "RAV2" DEFAULT TABLESPACE "RAV2";

赋予权限
GRANT "CONNECT" TO "RAV2";
GRANT "RESOURCE" TO "RAV2";

连接
CONNECT RAV2/RAV2;

plsql常设的字符集：
set nls_lang=simplified chinese_china.zhs16cgb231280 
set nls_lang=simplified chinese_china.ZHS16GBK 
set nls_lang=simplified chinese_china.Utf8  

     本文转自 cuiyingfeng 51CTO博客，原文链接：http://blog.51cto.com/cuiyingfeng/497226，如需转载请自行联系原作者