1:创建表空间 wspspace,maxsize unlimited是大小不受限制

Sql代码

create tablespace wspspace

datafile 'D:/dev/oracle/tablespace/wspspace.dbf' size 300M

autoextend on

next 50M

maxsize unlimited

2.创建用户

create user wsp identified by wsp default tablespace wspspace;

3.分配权限

grant connect,resource,create view to wsp;