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;