ORACLE 创建表空间及用户

数据库笔记：

create temporary tablespace space_temp 

tempfile 'D:\DB\oradata\orcl\space_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 1024m  
extent management local;


create tablespace space_data  
nologging  
datafile 'D:\DB\oradata\orcl\space_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize 1024m  
extent management local


create user test identified by test  
default tablespace space_data  
temporary tablespace space_temp


create user xining identified by xining  
default tablespace space_data  
temporary tablespace space_temp

grant connect,resource,dba to test

扩大内存

-XX:PermSize=256M 
-XX:MaxPermSize=512M