oracle 1１g创建表空间与赋予用户全校性

create tablespace DATA_XINKEJI
'D:\oracle11\oradata\orcl\XINKEJI.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

create tablespace DATA_XINKEJIS
logging
datafile 'D:\oracle11\oradata\orcl\XINKEJIS.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

 

create user XINKEJI identified by XINKEJI
default tablespace DATA_XINKEJIS
temporary tablespace DATA_XINKEJI;

grant connect,resource,dba to XINKEJI;